How to retrieve range of 10th rows to 20 th rows from total
rows from a database table.? (Not from Dataset)
- 10 Answers
- 16763 Views
- Cognizant, Infosys, I also Faced
- E-Mail Answers
Answer Posted / adhar jain
With temp As
(
Select columns,
row_number() Over (Order By sort_Column) As row_num
From table
)
Select * from temp where row_num between 10 and 19
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is lookup override?
What is difference statement and preparedstatement?
Is it safe to delete log files?
What are the underflow and overflow behaviors on float literals?
Do you have any idea about the tcl commands?
How to use values from other tables in update statements in ms sql server?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What is the recommended total size of your memory optimized tables?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
what are the different types of SSRS reports?
What do you mean by data integrity?
What are different types of collation sensitivity?
What are different types of replication in sql server?
How do you drop an index?
In what version of sql server were synonyms released?
