How to retrieve range of 10th rows to 20 th rows from total
rows from a database table.? (Not from Dataset)
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
Can we delete data from a view?
Mention the different types of triggers?
Differentiate between ms sql server reporting services vs crystal reports?
What is difference between order by and group by?
Explain about temporary stored procedure?
What is the definition for sql server 2000?
How many instances per computer are there in sql server 2000?
What command is used to rename the database?
Explain the usage of floor function in sql server.
How to rebuild the master database?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
What are exact numeric data types in ms sql server?
Is it important for a database administrator to understand the operating system and file access?
What are trace flags?
what is the maximum size of a row? : Sql server database administration