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

Explain features of analysis services?

987

What is triggers in ms sql server?

1106

Can you explain the disadvantages/limitation of the cursor?

974

What is the difference between DataRow.Delete() and DataRow.Remove()?

1222

What is normalization of database? What are its benefits?

1018

Explain logical operators in sql server?

1100

What do you understand by hotfixes and patches in sql server?

976

How can you hide the sql server instances?

1013

What are .mdf files?

931

How to convert a numeric expression from one data type to another?

1002

What is create statement?

936

How do you implement session management in SQL Server mode?

1088

Is mysql the same as sql server?

969

Explain a differential backup?

1001

Does union all remove duplicates?

1057