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
- 18344 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
Explain the steps to create and execute a user-defined function in the sql server?
what method you can use to reduce the overhead of Reporting Services data sources?
What is a hint?
How can I create a new template for import ? : sql server management studio
What is the contrast between sql and mysql?
What are the advantages of log shipping?
How to resolve the orphan use problem? : sql server security
How do users use Report Builder with SQL Server data sources?
What is the difference between indexing and hashing?
When do you think a developer should use sql server-based cursors?
Should you normalize audio?
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
What stored by the model? : sql server database administration
What is rank function?
What stored by the msdb?
