Top n to m result

[deception54]

I am trying to build a sql query where I will extract the top 10 to 20 results. I know how to make Top 10 queries using correlation queries, but I can't figure out how to extract top 10 to 20 rows without getting the top 20 result set. Anyone knows how to proceed, or where to find proper documentation for this task? All SQL tutorials I find are too newbie-oriented.

Thanks!

[[deleted]]

"All SQL tutorials I find are too newbie-oriented."

how modest :-)

which database are you using?

"but I can't figure out how to extract top 10 to 20 rows without getting the top 20 result set"

Actually, there are no databases who can do that. They all have to generate the entire resultset. But some databases can return only the records you are looking for.
And in some cases, like Oracle, you can't even do that.

[Anon]

If you use Mysql, try this :

select *
from "table_name"
where "condition"
order by "condition to get top 20 rows"
limit 10,20

By adding "limit 10,20" the query will return only rows 10 to 20 and you won't get the 10 first rows

[[deleted]]

"By adding "limit 10,20" the query will return only rows 10 to 20 and you won't get the 10 first rows"

not quite right, LIMIT 10,20 will return records 10 to 30. Remember, it's LIMIT offset,length. It retruns LENGTH records starting at record OFFSET.

LIMIT 10,100 will return 100 records starting at record 10.

Note: MySQL itself still processes the first 10 records, it just does not send them to PHP. So if you request LIMIT 10000,10 MySQL will still take the time to parse those frist 100000 records!

[deception54]

Thanks guys for your support, it helps me a lot!