How to retrieve range of 10th rows to 20 th rows from total
rows from a database table.? (Not from Dataset)
- 10 Answers
- 16778 Views
- Cognizant, Infosys, I also Faced
- E-Mail Answers
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 coalesce and check constraint in sql server?
State a few properties of relational databases?
What do we have to check in database testing?
How many levels of sp nesting are possible?
What are temporal tables in sql server 2016?
Why transaction is important?
Can we use pragma autonomous_transaction in trigger?
Explain table valued parameters in sql server? Why tvp used?
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
Explain acid?
Describe and explain about SQL native client?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
What is the chart in report?
Differentiate between SQL and ORACLE joins and write their syntax.
Mention the different types of replication in sql server.
