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

What is database replication? What are the different types of replication you can set up in sql server?

950

How many primary keys are possible in a table?

918

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

943

What is clustered index

993

How to create a large table with random data for index testing in ms sql server?

1020

How display code or Text of Stored Procedure using Sql query in Sql Server ?

1133

what happens on checkpoint? : Sql server database administration

1082

What is merge join?

1190

What is the purpose of update statistics and scope_identity() function?

1088

What is dirty page?

963

Explain index in sql server?

1004

Explain logical operators in sql server?

1097

Define master database?

1048

Tell me something about security and sql azure?

114

What is the difference between value type and reference type?

915