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
How many full-text indexes can a table have?
How to throw custom exception in Stored Procedure?
Do you think BCNF is better than 2NF & 3NF? Why?
What is @@error in sql?
What is resource governor in sql server?
how to determine the service pack currently installed on sql server? : Sql server database administration
What are different types of statements that are supported by sql?
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.
Why and when do stored procedure recompile?
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
What happens when converting big values to numeric data types?
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
How to remove duplicate rows from table except one?
What are cursors and when they are useful?
What do you do in data exploration