Hi all,

   I am trying to find how can i translate limit in select statment in mysql to ms sql statment is there is any thing like it in ms sql?

sms

select whatever from table limit 10

is

select top 10 whatever from table 

but mysql " Select what ever from table limit 10,20 " i can do range 10 to 20 or 20 to 40.

how can i do that in Sql can i do top 10,20 ?

Thank you so much

Sms

No, not exactly. TOP sucks compared to LIMIT. You want it for paging, like I did?

If you have sql server 2005, you can do this sort of hack like I had to.

select * from (
    SELECT TOP 100 PERCENT ROW_NUMBER() OVER (ORDER BY myTimestampField DESC) AS ROWNUMBER,
    field1, field2, blah
   from myTable ) AS TBL
where ROWNUMBER between 10 and 20
 

thank you so much

sms