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
Which Is Faster MVC or ASP.net ?
Give an example of what might be best suited to place in the application_start and session_start subroutines?
What is the appSettings Section in the web.config file?
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?
How information about the user's locale can be accessed?
What are the asp.net 2.0 features?
How do you design a website with multilingual support in ASP.NET ?
What is the difference between ASP.NET Webforms and ASP.NET MVC?
Explain the difference between overriding and overloading?
What are the various ways to send content from one page to another?
What is custom events? How to create it?
How u refer webservices?
What is the good practice to implement validations in aspx page?
What is postback and autopostback in asp.net?
What is hidden field in asp.net?