DotNet Academy of Rajesh Rolen

Solutions by Rajesh Rolen

How to implement keyword "Limit" like functionality in MS SQL Server

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

0 comments:

Post a Comment

About this blog

Blog Archive

My Blog List

Advertise On This Site

Site Info

Advertise on this Site

To advertise on this site please mail on RajeshRolen@gmail.com

Information Source

About

Pages

Dot Net Academy

Advertis in This Area of Site

Powered by Blogger.

Followers

Blog Archive

Search This Blog