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 create a user to access a database in ms sql server using "create user" statements?

516

How do I start sql server?

526

Differentiate between a local and a global temporary table?

540

What is data source in connection string?

483

what is memory-optimized nonclustered indexes

545

Can you use order by when defining a view?

567

explain declarative management framework (dmf) in sql server 2008?

574

Explain multiserver query

547

Where to find ntwdblib.dll version 2000.80.194.0?

546

What is difference between joins and subqueries?

527

What purpose does the model database server?

650

Write the queries for commands like Create Table, Delete table, Drop Table etc.

602

List the various tools available for performance tuning?

478

What is the use of “join” in sql server?

561

What is open database communication (odbc)?

565