use Row_Number() function to check for the condition so that the row numb

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

Question Posted / govardhana r

Answer Posted / govardhana r

use Row_Number() function to check for the condition so
that the row number is between 10 and 20

Is This Answer Correct ?

10 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how to invoke a trigger on demand? : Sql server database administration

1073

Explain how to send email from sql database?

1043

What are the different types of normalization?

1157

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

954

What are commonly used odbc functions in php?

1011

How to use subqueries in the from clause in ms sql server?

1159

How to specify the collation for a character data type in ms sql server?

1019

What do you understand by mirroring and mention the advantages of the mirroring?

1059

What are statistics?

986

Why main is user defined function?

1006

How to assign null values to variables or columns?

967

What is a result set object returned by odbc_exec()?

1017

What is difference between table aliases and column aliases? Do they affect performance?

959

What is for xml in sql server?

1057

What will be query used to get the list of triggers in a database?

994