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


Please Help Members By Posting Answers For Below Questions

Explain the database you used in your final year project?

538


Indexes are updated automatically is the full-text index also updated automatically?

624


What are the disadvantages of using the stored procedures?

551


can you instantiate a com object by using t-sql? : Sql server database administration

521


How to get a list all databases on the sql server?

583






Which language is supported by sql server?

559


Are null values the same as that of zero or a blank space?

579


How to restore performance issues and how to check?

1526


What do you mean by recursive stored procedure?

513


Can two tables share the same primary key?

508


What is sql server database?

500


Explain transaction server auto commit?

536


How do you create a clustered index?

532


What does COMMIT command do?

626


What is the difference between a unique key and primary key?

515