How to retrieve range of 10th rows to 20 th rows from total
rows from a database table.? (Not from Dataset)
Answer Posted / govardhana r
use Row_Number() function to check for the condition so
that the row number is between 10 and 20
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What is normalization? Describe its different types.
What is clustered index
What is create statement?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
What to check if a User database is locked?
What are the differences between user defined functions and stored procedures?
What is the difference between char, varchar and nvarchar?
What are the steps you can take to avoid “deadlocks”?
How to find the second highest salary of an employee?
When I delete any data from a table, does the sql server reduce the size of that table?
What is Service Broker in sql server 2012?
What is single-user mode?
How do you run a trace?
What are the advantages of having an index on the sql server?
What is the difference between cartesian product and cross join?