This is New Feature in SQL Server 2012 i see this feature is very good .

OFFSET  command  —- provides a starting point for the SELECT statement , Form where the Select will begin

FETCH command   —– provides how many records to return at a time

in SQL Sever 2012

Use AdventureWork


SELECT Name,ModifiedDate  FROM Production.Culture


offset 2 rows ——- Select the rows from tha table expected the 2 rows

FETCH NEXT 3 ROWS ONLY — show the first 3 rows from the result return after the OFFSET Command

IF you want to make this statment in Oldest Version you will make it like this

Use AdventureWork


SELECT top 3 Name,ModifiedDate  FROM Production.Culture

where name not in (‘Arabic’,’Chinese’)


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.