SELECT * FROM ( SELECT NTILE(2) AS div, * FROM ( SELECT TOP(2

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

Question Posted / x.cannon

Answer Posted / x.cannon

SELECT * FROM
(
SELECT NTILE(2) AS div, * FROM
(
SELECT TOP(20) FROM <table_name>
) AS tmp
) AS tmp WHERE div = 2

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is fill factor and pad index?

1005

How to manipulate data from one table to another table ?

963

What is the difference between a "where" clause and a "having" clause?

1156

How to create a stored procedure with a statement block in ms sql server?

1061

How to update muliple row in single query?

1046

What is the importance of three tier architecture?

1079

What are the options which must be set to allow the usage of optimistic models?

956

What is recompile sql server?

1028

How can sql server instances be hidden?

943

What are commonly used mssql functions in php?

1068

what are user defined datatypes and when you should go for them? : Sql server database administration

1002

Why use view instead of a table?

936

Explain what is row_number function?

1012

What is row-level compre?

990

What is format parameter in ssrs?

145