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

10 Answers
18343 Views
Cognizant, Infosys, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the reporting services components?

142

What type of Index will get created after executing the above statement?

1090

What are the steps to insert a table?

940

How will you hide an attribute? : sql server analysis services, ssas

950

Tell me what are cursors and when they are useful?

944

What is the difference between DATETIME2 and DATETIME?

1070

Can we install sql server 2016 on windows 7?

1124

What are translations and its use? : sql server analysis services, ssas

1034

Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?

190

What is resource governor?

962

How do I create a trace in sql server?

1023

What are trace files?

946

Explain log shipping?

1005

What is the recommended total size of your memory optimized tables?

959

what are the critical issues you have resloved in your company

1955