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

What are the basic features of a trigger in ms sql server?

1199

Explain how you can deploy an SSRS report?

150

Explain acid?

1086

How can you insert values in multiple rows using one Insert statement?

1103

When should you use an instead of trigger?

958

Which tools are available to manage SQL Azure databases and servers?

115

How to end a stored procedure properly in ms sql server?

1093

How will you monitor replication latency in transactional replication? : sql server replication

1150

How to find tables without indexes?

1090

What is rank function?

1034

How many databases instances are there in sql server 2000?

1103

What is transaction server distributed transaction?

1061

What is an entity-relationship diagram (erd)?

1215

What are the different acid properties?

1069

What is repeatable read?

1023