Answer Posted / Navjot Singh
You can use a combination of `ROW_NUMBER()` and `OFFSET` to get the second 5 rows. Here is an example:n`SELECT * FROM ( SELECT *, ROW_NUMBER() OVER(ORDER BY column_name) AS row_number FROM table_name ) x WHERE row_number BETWEEN 6 AND 10`
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How raid can influence database performance?
How can we solve concurrency problems?
Where can you add custom error messages to sql server?
Can we shrink data file in sql server?
Can you index views?
What is an indexed view?
What is acid mean in sql server?
Can sql servers link to other servers like oracle?
What kind of problems occurs if we do not implement proper locking strategy?
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?
Why we use the openxml clause?
How to remove duplicate rows from table except one?
what is the difference between openrowset and openquery?
What is self contained sub query?
What is a view in sql?
