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

What is bit data type?

1042

What is the server name in sql server?

1019

How to drop an existing table?

1012

Explain the different types of backups available in sql server? : sql server database administration

932

Can a table have 2 primary keys?

987

What is blocking?

1074

How to call stored procedure using http soap?

1082

Tell me what is a linked server?

1040

What is 2nf in normalization?

1005

What is exclusive locks?

964

How to create a stored procedure with a statement block in ms sql server?

1072

What is data file in computer?

956

How to identify current user in ssrs report?

405

last function used in MS Access to convert sql what function will use in sql

2078

What is the bookmark lookup and rid lookup?

998