How to retrieve range of 10th rows to 20 th rows from total
rows from a database table.? (Not from Dataset)
- 10 Answers
- 16768 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
Explain the concepts and capabilities of sql server?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
What is RMS migrations?
How to select some specific rows from a table in ms sql server?
How we create SQL Server 2005 Reporting Services ? Give me Sample
What is normalization? What number of normalization shapes are there?
Why truncate is ddl command?
What Are the Main Features of SQL Azure?
What is a field in a table?
Define tool Manage Statistics in SQL Server 2000 query ?
what is the difference between Delete and Truncate command in SQL
What are the pre-defined functions in the sql server?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
Why do we use trigger?
