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 a pixel url?

887

How many types of state management are there in asp net?

993

What are the properties of the eventargs argument when capturing keyboard events?

1028

What is the full form of asp.net?

978

What is asp.net introduction?

967

What is the default authentication mode for asp.net?

1066

What methods are fired during the page load? Init()

925

What are the types of validation in asp net?

977

What is the full meaning of asp.net?

995

Explain About duration in caching technique

1023

What is the maximum amount of memory any single process on windows can address?

981

What is the difference between server-side scripting and client-side scripting?

948

Explain how can we inherit a static member?

947

What is is post back property in asp net?

973

What is ashx file in asp.net?

1022