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 different types of normalization?

1156

What are the types of table?

977

why would you use sql agent? : Sql server database administration

1200

What is an execution plan?

1134

What is user-defined inline table-valued function?

936

What is cross join in sql server joins?

1130

What are the aggregate and scalar functions?

1053

What is a performance monitor?

967

What is right outer join in sql server joins?

1171

Give an example of why you would want to denormalize a database

971

Is truncate autocommit?

931

What is the chart in report?

158

How exceptions can be handled in sql server programming?

1006

How do I know if localdb is running?

941

What is snapshot report?

165