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
- 18442 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
What is compression - row-level and page-level compression?
Explain unique key in sql server?
What are the differences between left join and inner join in sql server?
what are the three command line utilities and what are their primary functions?
what is hash nonclustered index
When a primary key constraint is included in a table, what other constraints does this imply?
What are the restrictions while creating batches in sql server?
What is the template in sql?
How to retrieve error messages using odbc_errormsg()?
What is partition index in sql server?
How to use subqueries with the in operators in ms sql server?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
What are parameterized reports?
When would you use a before or after trigger?
Can we update data in a view?
