limiting a query

[pelegk1]

can i linit a query like in mysql Server where i can ask in the query
lines 20-30 like this:
select * from table1 limit 20,10
which means tgive me the first 10 rows sarting with line 20
thnaks in advance
peleg

[buntine]

Are you using MS Access? If so, I do not think you can limit the query in the same way. You may be able to, but I have never come across it.

You can, however, use the TOP clause.

SELECT TOP 10 * FROM TableName ORDER BY TableNameID;

If you're using MS SQL, you may be able to use a CASE or similar conditional statement to begin ordering at a certain point. See: http://www.siteexperts.com/forums/vi...d=17279&Sort=0

Regards.

[buntine]

Workaround for MS SQL: http://www.planet-source-code.com/vb...d=850&lngWId=5

[pelegk1]

i work with sql server
and what i wanted to do is paging - sorry for not using the correct word from starts!
the link i used is :
http://www.asp101.com/articles/recordsetpaging/index.asp
and the solution that buntine gave me in the link i have a better 1 i belive :

select top 5
 * 
from 
(
            select top 10
             *
            from 
             companies
            order by row_num DESC
)aa
order by row_num DESC 

simple isnt it but not effective when i have 1 million rows!

[buntine]

But good enough.