With temp As ( Select columns, row_number() Over (Order By sort

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

Question Posted / adhar jain

Answer Posted / adhar jain

With temp As
(
Select columns,
row_number() Over (Order By sort_Column) As row_num
From table
)
Select * from temp where row_num between 10 and 19

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Do you know what is replace and stuff function in sql server?

1010

What should be the fill factor for indexes created on tables? : sql server database administration

1138

What are different types of subquery?

1244

What is difference between rollback immediate and with no_wait during alter database?

1089

What is identity?

1013

how to avoid cursors? : Sql server database administration

969

When is update_statistics command used?

1042

Explain the difference between functions and stored procedures in sql server?

978

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

974

What is the use of stored procedure?

939

What are different types of table joins?

1004

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

1025

Write a SQL query to make a column as unique?

1039

What is the default order of an order by clause?

994

What is bcnf normalization form?

1114