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

What is trigger explain with program?

1017

Define candidate key, alternate key, and composite key.

968

How do we know if any query is retrieving a large amount of data or very little data?

1034

How to rebuild indexes with alter index ... Rebuild?

1182

What happens to a statement batch if there is a compilation error?

1011

What is importing utility?

1039

What are the properties and different types of sub-queries?

1051

Can the “if update (colname)” statement be used in a delete trigger?

1034

What is inner join? Explain with an example?

1286

What is the sql profiler?

1000

How to create new databases with "create database" statements?

1067

Does table partitioning improve performance?

1015

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

1017

What are triggers? How do you invoke a trigger on demand?

1365

How do I clean up sql server transaction log?

1126