SELECT E.* FROM (SELECT ROW_NUMBER() OVER (ORDER BY EmpID) AS RowCounts,

How to retrieve range of 10th rows to 20 th rows from total
rows from a database table.? (Not from Dataset)

Question Posted / newbie

Answer Posted / newbie

SELECT E.* FROM
(SELECT ROW_NUMBER() OVER (ORDER BY EmpID) AS RowCounts,
Salary FROM Emp) AS E
WHERE E.RowCounts BETWEEN 10 AND 20

Is This Answer Correct ?

8 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is truncate autocommit?

938

Can primary key be a foreign key?

1058

What does it mean if @@cursor_row returns a negative number?

989

What is collation sensitivity? Explain different types.

1010

What are the different types of triggers in SQL SERVER?

1137

how can u get last observation in an unknown dataset ?

2436

Explain the advantages of merge replication?

951

Does union all remove duplicates?

1062

What is coalesce in sql server?

1052

What is the difference between dropping a database and taking a database offline?

1172

Can we insert data into view sql server?

927

What is the importance of three tier architecture?

1093

what is denormalization and when would you go for it? : Sql server database administration

1183

Can one drop a column from a table?

1020

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

1042