Interested to Buy Any Domain ? << Click Here >> for more details...
How to retrieve range of 10th rows to 20 th rows from total
rows from a database table.? (Not from Dataset)
- 10 Answers
- 18678 Views
- Cognizant, Infosys, I also Faced
- E-Mail Answers
Answer Posted / upendra
USE CTE
http://www.4guysfromrolla.com/webtech/071906-1.shtml
WITH CTE_Table AS ( SELECT
Row_number() OVER (
ORDER BY
sort_Column ) AS RowNum
, premiumamount
FROM
shplaninfo )
SELECT
*
FROM
CTE_Table
WHERE
RowNum BETWEEN ( 10 ) AND ( 19 )
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
How to delete a database in ms sql server?
How to find the second highest salary of an employee?
What are the joins in sql server? : sql server database administration
Explain a checkpoint?
What is the log shipping?
what happens on checkpoint? : Sql server database administration
Where is localdb stored?
Define right outer join in sql server joins?
Explain the phases a transaction has to undergo?
What are the different methods available under sqlcommand class to access the data?
What is the importance of a recovery model?
What is the syntax to execute the sys.dm_db_missing_index_details?
Your table has a large character field there are queries that use this field in their search clause what should you do?
what are different types of backups available in sql server? : Sql server database administration
How to execute function in stored procedure sql server?
