With temp As ( Select columns, row_number() Over (Order By sort

How to retrieve range of 10th rows to 20 th rows from total
rows from a database table.? (Not from Dataset)

Question Posted / adhar jain

Answer Posted / adhar jain

With temp As
(
Select columns,
row_number() Over (Order By sort_Column) As row_num
From table
)
Select * from temp where row_num between 10 and 19

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to create a trigger for insert only?

979

What are different types of subquery?

1176

What is the Main Difference between ACCESS and SQL SERVER?

1064

Do you think BCNF is better than 2NF & 3NF? Why?

1226

How to create a view with data from multiple tables?

963

What is read uncmmited?

1010

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

932

Can you explain about buffer cash and log cache in sql server?

904

What is normalization and what are the advantages of it?

920

What are “phantom rows”?

1607

What is difference between commit and rollback when used in transactions?

902

What is fill factor and pad index?

950

Can the “if update (colname)” statement be used in a delete trigger?

943

How to generate random numbers with the rand() function in ms sql server?

1044

What is an expensive query?

879