How to retrieve range of 10th rows to 20 th rows from total
rows from a database table.? (Not from Dataset)
- 10 Answers
- 15633 Views
- Cognizant, Infosys, I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
What are the rendering extensions of ssrs?
Can we write trigger for view?
What are the different types of replication you can set up in sql server?
What is the use of RDBMS?
What is difference between temp table and cte?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
What are the requirements to use odbc connections in php scripts?
What are the advantages of using a stored procedure?
What is transaction server consistency?
What is cached report?
What is log shipping?
How can you append an identity column to a temporary table?
How to create dbo table in sql server?
what is a self join? : Sql server database administration
Other than truncate statement, which other command can by-pass the trigger on the tables?
