select * from mytable limit 10, 20
the equivalent in MS SQL Server would be:
select top 20 * from mytable where pk not in (select top 10 pk from mytable order by pk) order by pk
How to implement keyword "Limit" like functionality in MS SQL Server
Posted by
Rajesh Rolen
at
Tuesday, October 6, 2009
Labels: SQL , SQL Interview Questions , sqlserver
0 comments:
Post a Comment