How to retrieve range of 10th rows to 20 th rows from total
rows from a database table.? (Not from Dataset)
- 10 Answers
- 16765 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 filter out duplications in the returning rows in ms sql server?
How to reaname table name without using sp_Rename in sql server..?
How to query multiple tables jointly?
What are the restrictions while creating batches in sql server?
What is postgresql server?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
Can we call future method from queueable?
What is difference between getdate and sysdatetime in sql server 2008?
Explain an incremental backup?
Explain transaction server distributed transaction?
Do you know hot add cpu in sql server 2008?
Is it possible in sql table to have more than one foreign key?
What are the differences between clustered and non-clustered index?
What are the components of dbms?
What is the dbcc command and why is it used?
