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

Explain what is meant by replication of database?

1026

How to call a function from a stored procedure in SQL Server ?

1024

Define a cross join?

1008

Is sql server is free?

973

How do you improve the performance of a SQL Azure Database?

137

What is default constraint in ms sql server?

1026

Determine how to use the inserted and deleted pseudo tables?

985

What is the use of nvl work?

994

Do you know what are different types of replication in sql server?

1090

What is global temp table?

990

How to create dbo table in sql server?

949

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

1001

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2743

List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

183

Mention the different types of triggers?

1108