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

Explain what are the database objects? : SQL Server Architecture

1077

How to get the query of a table in sql server?

898

What happens to a trigger with multiple affected rows?

941

What is simple indexing method?

1030

How many clustered indexes there can be on table ?

1038

Define self join?

1028

What is the default value of an integer data type in sql server 2005?

951

What are the five characteristics of good data?

918

What is the difference between a function and a trigger?

1080

How to execute the cursor queries with "open" statements?

1180

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

978

What is sql collation?

1207

Do you know what is user defined datatypes and when you should go for them?

966

What is extent? Types of extents?

1192

Do you know the policy based administration feature of sql server 2008?

959