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 difference between standardization and normalization?

1019

What is a unique key constraint?

970

What should be the fill factor for indexes created on tables? : sql server database administration

1098

What is model database? : SQL Server Architecture

1059

Difference between primary key and clustered index?

932

Tell me what is difference between view and materialized view?

881

How to create a view on an existing table in ms sql server?

1051

Explain relational data?

855

Can binary strings be converted into numeric or float data types?

967

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

936

What are window functions in sql server?

936

List the different types of collation sensitivities in sql server?

972

How to drop an existing user defined function in ms sql server?

979

what authentication modes does sql server support? : Sql server database administration

1000

What are clustered and non-clustered index?

948