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

How to provide column names in insert statements in ms sql server?

1129

How will you monitor replication latency in transactional replication? : sql server replication

1122

What is enhanced database mirroring in sql server 2008?

954

What are the properties of sub-query?

1060

Explain the difference between clustered and non-clustered index?

906

Is INSTEAD OF trigger directly applicable to Table ?

997

Why transaction is important?

962

What are the restrictions that views have to follow? : SQL Server Architecture

975

Explain active/passive and active/active cluster configurations?

1046

What is the Difference Between Primary and Foreign Key?

987

which backup strategy you are following at ur company

2132

How to get nth highest salary from employee table.

1148

What are the properties and different types of sub-queries?

990

What are rows and columns?

999

What is thr feature of change data capture?

962