you can use top keyword to fetch the first 20 records from sql server.Here

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

Question Posted / arunbhararthi

Answer Posted / arunbhararthi

you can use top keyword to fetch the first 20 records from
sql server.Here is the query for that:

for example:
select top20 empname from emp.

Is This Answer Correct ?

5 Yes

10 No

Please Help Members By Posting Answers For Below Questions

What is the difference between adding reference in solution explorer and adding references by using ?

1076

Which method is used to force all the validation controls to run?

1036

What is postback request?

976

Why is it preferred to not use finalize for clean up?

991

What is difference between Fragment Caching and Page Caching in ASP.NET?

1016

How can we create custom controls in asp net?

1015

Does google crawl redirects?

958

Define the term Web Garden?

952

how to include timer or counting time to display next page in asp.net

2150

Define view state.

938

What is http post and http get?

1009

How would you enable impersonation in the web.config file?

995

What is a 404 redirect?

1052

What is the use of global.asax file?

1060

What are the server control tags in asp.net.?

1058