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

Can you pass expressions to function parameters?

1153

Explain syntax for dropping triggers?

969

What do you mean by an execution plan?

1188

Differentiate between sql temp table vs table variable?

927

How to convert a unicode strings to non-unicode strings?

1157

What are scheduled tasks in sql server?

1140

What happens if you insert a duplicate key for the primary key column in ms sql server?

1025

What are the different type of replication in sql server?

1015

Explain full-text query in sql server?

1054

Is t sql the same as sql server?

1023

What is the difference between having clause and where clause in sql server?

1169

How to scale out a federation by Sql statement?

118

What is difference between commit and rollback when used in transactions?

1019

What stored by the tempdb ? : sql server database administration

1098

List all types of constraints in sql server?

1093