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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe session handling in a webfarm?

762


What is the base class from which web forms are inherited?

768


is there any third party tools are using in .net technologies? what are there ? give me the brief introduction?

2196


We are using Jscriopt validations and at clint site javascript is not running that time validation would work? if yes then how it would behave?

1652


Why do we need asp.net?

794


What r the asp.net list controls and diff. Between them?

740


Where is the session stored?

875


Using code explain Configuration Management

1645


What is the purpose of asp.net?

748


how to debug web services on consumer side?

820


What is the best Macanism to clear the Cache in asp.net

972


What is windows active directory authentication?

799


What is the basic difference between asp and asp.net?

767


How to store checkbox value in database in asp.net mvc? : Asp.Net MVC

721


What are user controls?

783