How to retrieve range of 10th rows to 20 th rows from total
rows from a database table.? (Not from Dataset)
- 10 Answers
- 15645 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 is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What are different types of subquery?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
How to perform backup for certificates in sql server? : sql server security
What are different types of constraints?
What is data mart? : sql server analysis services, ssas
How to insert multiple rows with one insert statement in ms sql server?
How you can minimize the deadlock situation?
what are different types of backups available in sql server? : Sql server database administration
what is sql server? : Sql server database administration
Tell me what is a linked server?
What types of replication are supported in sql server?
Mention the differences between sql server and mysql.
What is Federation Root Database?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
