How to retrieve range of 10th rows to 20 th rows from total
rows from a database table.? (Not from Dataset)
- 10 Answers
- 16769 Views
- Cognizant, Infosys, I also Faced
- E-Mail Answers
Answer Posted / vinay
SELECT TOP 10
ID,Name,Address
FROM TableName
WHERE ID NOT IN (SELECT TOP 10 ID FROM TableName)
| Is This Answer Correct ? | 18 Yes | 2 No |
Post New Answer View All Answers
What are “lost updates”?
Can you index views?
What are two difference between sql azure and azure tables?
What are the acid properties?
What are date and time data types in ms sql server?
What is sql server query analyzer?
What is the difference function and stored procedure?
Explain the steps to create and execute a user-defined function in the sql server?
What are different types of data sources?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
How do I find the transaction log size in sql server?
Where sql server user names and passwords are stored in sql server? : sql server database administration
How to turn off warning messages during php execution?
Tell me about normalization in DBMS.
What is the maximum size of sql server database?
