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

what are the disadvantages of cursors? : Sql server database administration

970

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

858

What is the difference between online clustering and Offline clustering?

2356

What is an inner join?

915

How to access the deleted record of an event?

976

What is the difference between migration and upgradation in sql server?

1038

What Are the Main Features of SQL Azure?

115

What is BCNF? How is it better than 2NF & 3NF?

963

Explain alternate key, candidate key and composite key in sql server?

860

Can you always create a cache of a report?

156

How do I create a stored procedure in dbml?

927

What is query processing?

881

What is sql server locking?

936

How do we Backup SQL Azure Data?

106

How to get the definition of a user defined function back?

1000