select * from table name where rownum <= 20;

if i have 1000 records and i want to access 20 ata time
from SQL server, what will be the query?

Question Posted / irfan

Answer Posted / irfan

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are ASHX files?

1092

Why we use content place holder in asp.net?

1032

What are the different types of Caching techniques in ASP.NET?

1052

How much is the pay-for-use service if I chose not to use microsoft-sponsored advertising?

951

What is different authentication mechanisms used in ASP.NET?

1123

What is localhost in asp.net?

1013

Any disadvantages in Dataset and in reflection ?

3248

What are the differences between application object and session object?

995

What should you do is you want to remove an existing component but would like to make some funtionalities?

1934

Briefly describe the role of global.asax?

988

What is the procedure to create the environment for asp.net? : asp.net mvc

1041

What is the full meaning of asp.net?

1056

How do you create a master page?

1030

What is a runtime version?

1058

Do you know using sql cache invalidation?

1017