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 a default skin and a named skin?

1084

How many types of session in ASP.NET

1076

Write the different features of a Thread and a Process?

1141

What is application variable in asp.net?

917

What is the difference between stored procedure vs function?

1040

What is GAC in ASP.NET 2.0

1153

Explain the concept of event bubbling in ASP.NET?

1098

What are server-side comments in ASP.NET?

945

Can we use MSSql as backend in asp.net...if yes then How.?

1034

What is a page life cycle?

1043

Briefly describe the role of global.asax?

988

How is application management and maintenance improved in asp.net 2.0?

994

What is http session state?

966

Will the asp.net validators run in server side or client side? How do you do client-side validation in .net?

946

When maintaining session through sql server, what is the impact of read and write operation on session objects?

983