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 provide default values to function parameters?

1108

Which are the new data types introduced in sql server 2008?

866

How to create hyperlink from returned sql query ?

1110

Difference between uniqe index and uniqe constraint?

950

What will happen if a column containing char type data is changed to the nchar data type?

1079

Write an sql query to find first weekday of the month?

899

How to test odbc dsn connection settings?

1001

What are the advantages of paper records?

950

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

1188

Why do we use functions?

895

What do you understand by integration services in sql server?

945

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

990

What is transact-sql language?

1055

Explain the usage of floor function in sql server.

945

What is a subquery in a select query statement in ms sql server?

1115