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
- 18060 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
You want to implement the one-to-one relationship while designing tables. How would you do it?
Can binary strings be converted into numeric or float data types?
What is relationship? What number of sorts of relationship are there?
What samples and sample databases are provided by microsoft?
If the job running very slow what is the action you do
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
What is nonclustered index with included columns ?
Explain what is “asynchronous” communication in sql server service broker?
What is difference between after and before?
what's new in sql server 2016?
what are the different stages of Report Processing?
What is enhanced database mirroring in sql server 2008?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
Explain transaction server explicit transaction?
