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
- 18430 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
How do I find the sql server version?
How can you manage sql azure security?
What is amo? : sql server analysis services, ssas
how to define testing of network layers? : Sql server database administration
What are the restraints imposed on the table design by a merge replication?
Write a SQL query to delete a table?
How to send a ssrs report from ssis?
Is it possible for a stored procedure to call itself or recursive stored procedure?
What is the use of keyword with encryption.
What is the difference between for auto and for nested?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
How to create an index on an existing table in ms sql server?
What is an expensive query?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
