Interested to Buy Any Domain ? << Click Here >> for more details...
How to retrieve range of 10th rows to 20 th rows from total
rows from a database table.? (Not from Dataset)
- 10 Answers
- 18412 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 are the grouping functions?
What are the purposes and advantages stored procedure?
What is mscorsvw.exe - process - microsoft .net framework ngen?
Can you explain important index characteristics?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
Name some of the open source software that you can use in alternative to SSR?
How to add a new dsn with the odbc driver for sql server?
What is the use of toad or sqldbx.?
How to create database with physical files specified in ms sql server?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
What is tabulation?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
How to use old values to define new values in update statements in ms sql server?
What is page-level compression?
Please illustrate physical database architecture? : SQL Server Architecture
