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

Do you know spatial data types - geometry and geography in sql server 2008?

1092

What is normalization 1nf 2nf 3nf?

1112

What is rs.exe utility?

164

Why use “pivot” in sql server?

1182

How to send a ssrs report from ssis?

183

Describe in brief databases and sql server databases architecture.

1069

How to create and drop temp table in sql server?

1100

What is the function of sql server agent windows service?

1150

Why should one not prefix user stored procedures with ‘sp_’?

1100

What is the difference between index seek vs. Index scan?

1066

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

1101

What are the tools available in market as an alternative to sql server reporting services?

138

what is a transaction? : Sql server database administration

1053

Explain a checkpoint?

1089

Can you please differentiate between a primary key and a unique key?

1050