select * from emp order by empid offset 4 rows fetch next 3 rows only

how to select 5 to 7 rows from a table, which contains 10 rows?

Question Posted / narayana

Answer Posted / narayana

select * from emp order by empid
offset 4 rows
fetch next 3 rows only

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

1068

How many categories of data types used by sql server?

1021

What are the differences between char and nchar in ms sql server?

1088

Can a table have 2 foreign keys?

908

What is log in sql server?

1151

How do you test your database? : sql server database administration

1026

What is candidate key with example?

983

How do I view views in sql server?

1012

What are the different Topologies in which Replication can be configured?

1185

How to create a simple user defined function in ms sql server?

1027

What are transactions and its controls?

1061

Define candidate key, alternate key, and composite key.

925

What do you mean by table and field in sql?

1015

Which sql server table is used to hold the stored procedure script?

950

How to see the event list of an existing trigger using sys.trigger_events?

1076