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

Does any body please help me what question's have asked for SSRS in the interview?

2202

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

951

how many bits ip address consist of? : Sql server database administration

944

whats new about truncate in sql server 2008?

2555

Do you know exporting and importing utility?

1106

How can sql injection be stopped? : sql server security

1104

Please explain go command in sql server?

1112

How to execute the cursor queries with "open" statements?

1242

What is the index requirement in SQL Azure?

What is instead of trigger sql server?

1080

what is the difference between openrowset and openquery?

1160

What is index fragmentation in ms sql server?

1145

What is server-level principal?

122

What is linked report?

137

What is the difference between a view and a stored procedure?

1091