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 select true false based on column value in sql server?

1082

Define Joins?

1073

how you can configure a running aggregate in SSRS?

199

A trigger can reference objects outside the current database? State true or false.

1060

What is difference between delete & truncate commands?

1140

What do you mean by data integrity?

1126

What are the requirements to use odbc connections in php scripts?

1156

What is the difference between system objects and user objects?

1211

Where is trigger in sql server?

1103

Why we need to use secondry database file? though, we can do same work using primary database file also.

7006

How many tables can be joined in SQL Server?

1111

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

1042

What are information schema views?

1028

Which rendering formats are affected by the pagesize properties?

151

Explain about integration services of Microsoft SQL server?

1084