SELECT TOP 10 ID,Name,Address FROM TableName WHERE ID NOT IN (SELECT

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

Question Posted / vinay

Answer Posted / vinay

SELECT TOP 10
ID,Name,Address
FROM TableName
WHERE ID NOT IN (SELECT TOP 10 ID FROM TableName)

Is This Answer Correct ?

18 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Mention the differences between local and global temporary tables.

1046

What is dirty page?

974

What is the maximum size per database for sql server express?

1058

Explain about SQL server 2005?

983

How can you start sql server in different modes?

977

Find first and last day of current month in sql server

1028

How to copy the tables, schema and views from one sql server to another?

1049

Why it is recommended to avoid referencing a floating point column in the where clause?

968

What is the meaning of resultset type_scroll_insensitive?

956

What is usually the first word in a sql query?

1136

What is the difference between dropping a database and taking a database offline?

1174

What to perform pattern match with the like operator?

883

State the difference between union and union all?

929

Tell me what is fill factor?

964

what are different types of backups available in sql server? : Sql server database administration

941