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

9 Answers
15359 Views
Mind Tree, I also Faced
E-Mail Answers

Answer Posted / irfan

select * from table name where rownum <= 20;

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What kind of data we can store in viewstate?

1095

What is different authentication mechanisms used in ASP.NET?

1189

there is two functions function a and function b like fun a(){.... ..... } fun b() { } in function b i write the coding to add two numbers and i need to dispaly the sum result in function a with out using global variable. how we do?

3146

Can we set which type of comparison we want to perform by the CompareValidator control?

1093

What is http protocol and how it works?

1101

What is __ requestverificationtoken?

1059

What is the difference between client-side and server-side validations in ASP.NET?

1236

What is a query string in a url?

1035

What are web beacons used for?

1067

Explain http handlers? Where we can use the http handlers?

1286

Which two new properties are added in asp.net 4.0 page class?

969

Why mvc is faster than asp.net? : Asp.Net MVC

1118

Explain what the contents of cookie?

1103

Where are session variables stored?

1007

What is asp.net futures?

1144