select Row_Number() over(order by Table_columnName) as number from TableN

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

Question Posted / philip

Answer Posted / philip

select Row_Number() over(order by Table_columnName) as
number from TableName where Table_columnName>=10 and
Table_columnName<=20

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can you edit the .rdl code associated with a linked report?

109

What is service broker?

588

What is entity data services?

578

What is the need for indexing?

500

How to insert multiple rows with a subquery?

531

Explain what is the difference between a local and a global temporary table?

514

What are group functions in query statements in ms sql server?

555

Do you know what are pages and extents? : SQL Server Architecture

550

what stored procedure would you use to view lock information? : Sql server administration

582

How do I find the query plan in sql server?

545

List some case manipulation functions in sql?

597

What is a non-clustered index?

564

why would you use sql agent? : Sql server database administration

527

What are the tool windows in sql server management studio? : sql server management studio

624

What are the three different part of rdl file explain them?

170