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

Which Is Faster MVC or ASP.net ?

782


Give an example of what might be best suited to place in the application_start and session_start subroutines?

740


What is the appSettings Section in the web.config file?

797


To display data in the combo box, prior to setting the Data Source, what kind of property on a Combo Box do you set with a column name?

815


How information about the user's locale can be accessed?

804


What are the asp.net 2.0 features?

748


How do you design a website with multilingual support in ASP.NET ?

758


What is the difference between ASP.NET Webforms and ASP.NET MVC?

821


Explain the difference between overriding and overloading?

744


What are the various ways to send content from one page to another?

711


What is custom events? How to create it?

830


How u refer webservices?

1699


What is the good practice to implement validations in aspx page?

848


What is postback and autopostback in asp.net?

755


What is hidden field in asp.net?

789