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 web.config file in asp?

1098

Where is the view state data stored?

936

Why and where this web.config file is used?

1011

Define the steps to set up validation control.

994

When using the Pager object, inorder to know which page to go, which property you have to set to grid?

946

How can I open ashx file in mobile?

1094

What is application variable?

888

Explain what are the advantages of asp.net mvc framework? : asp.net mvc

1038

Should I delete cookies?

928

where can i gather the materials for MCP certification

5202

Give an example of cookie abuse.

1022

Is asp.net mvc still used? : Asp.Net MVC

933

What is bound controls

1002

What are the advantages of passport authentication?

954

What is data binding in asp net?

1045