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

Explain Areas in MVC?

656

Explain the asp.net session state modes.

618

What is session in asp.net?

527

How to make paging concepts in datagrid in ASP.NET?

553

How can you handle unmanaged code exceptions in asp.net?

550

Is asp.net outdated?

530

Explain the difference between web user control and web custom control?

538

1.can we add connection string in global.asax?????????? 2.what are the default files included when we create new web application????

18518

What is the difference between ldap and active directory?

517

What is boxing and unboxing in asp.net?

667

What is cookieless session id explain in brief?

531

What is data grid view in asp.net?

535

Explain the updatepanel?

584

What is http response header?

563

Explain the advantages of asp.net.

544