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

How to define output parameters in stored procedures?

1029

Is it possible for a stored procedure to call itself or recursive stored procedure?

952

What is multilevel indexing?

930

What is the maximum rows in sql server table?

915

Which database stores information about replication?

1073

What is sleeping status in sql server?

1027

What is sql server 2000 work load governor?

1071

What is the size of transaction log file?

931

Can you please explain the difference between function and stored procedure?

1012

Which is better statement or preparedstatement?

935

Can you tell me about the concept of ER diagrams?

1082

How do you clear a log file?

1052

How to override dml statements with triggers?

1191

What the difference between UNION and UNIONALL?

1041

How to create an identity column?

1223