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

System variable and temporary variables

2183

What is the cartesian product of the table?

902

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

964

Will count(column) include columns with null values in its count?

1033

What are data resources?

853

Why Master database is required?

1058

How to download microsoft sql server 2005 express edition?

975

What is openxml in sql server?

1110

What is the use of set nocount on/off statement?

1027

What is an indice?

982

How to get all stored procedures in sql server?

937

How to connect of datebase with sql express.?

1050

What is the meaning of lock escalation and why/how to stop this? : sql server database administration

986

What is raiseerror? What is raiseerror?

1066

What are the source of constraints?

858