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

Write a query to find 5th highest amount paid from the customer table.

879

Explain datetime2 data type in sal server 2008?

856

Explain insert into select statement?

897

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

1058

What do you mean by data integrity?

995

What is data block and how to define data block size?

974

How to define and use table alias names in ms sql server?

1041

What is mscorsvw.exe - process - microsoft .net framework ngen?

899

What is CTE in SQL

874

When a primary key constraint is included in a table, what other constraints does this imply?

938

What is msdb database? : SQL Server Architecture

1057

How to get the definition of a user defined function back?

999

How many triggers you can have on a table?

933

can an automatic recovery be initiated by a user? : Sql server administration

892

What is sql azure database?

204