select * from (select row_number() over (order by empid) as row, * from

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

Question Posted / smitha

Answer Posted / smitha

select * from (select row_number() over (order by empid) as
row, *
from employee)a
where a.row between 4 and 5

Is This Answer Correct ?

7 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How to use subqueries in the from clause in ms sql server?

571

What are page splits? : SQL Server Architecture

544

What authentication modes does sql server support?

599

How to run sql server 2005 books online on your local system?

521

Define compound operators?

537

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

570

Explain system views?

584

Is natural join and equi join same?

532

What are 3 ways to get a count of the number of records in a table?

615

How to delete an existing row with delete statements in ms sql server?

556

How many databases instances are there in sql server 2000?

584

Why use “pivot” in sql server?

629

Explain filtered indexes?

560

What are cursors in ms sql server?

601

What are the different authentication modes in sql server? How can it be changed?

574