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

Why SQL Agent is used?

1204

How to execute a sql statement using odbc_exec()?

1218

List some advantages and disadvantages of stored procedure?

1063

How to throw custom exception in Stored Procedure?

1096

How can you check the version of sql server?

1160

Explain the difference between function and stored procedure?

997

What are the advantages of sql azure?

140

What is database architecture? : SQL Server Architecture

1099

your distribution database is full what will u do

2217

What is a data collection table?

1051

Difference between DELETE and TRUNCATE?

1096

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

1041

What happens if you add a new index to large table?

982

What is difference between order by and group by?

1054

What are key, name and value columns of an attribute? : sql server analysis services, ssas

1066