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

Answer Posted / irfan

select * from table name where rownum <= 20;

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between session and viewstate?

474


What do you mean by View State and what is its role?

537


Explain what are delegates?

582


Explain how do you validate the controls in an asp .net page?

523


What is cookieless session id explain in brief?

531






Which validator control you use if you need to make sure the values in two different controls matched?

652


What are the different properties of server control that exists?

568


What are the media types of http requests and response?

512


Is asp.net 64-bit enabled? How?

590


How does cookies work in asp net?

513


Explain different types of validators in asp.net?

535


Which method is used to perform all validation at the page level?

539


What is meant by server side scripting?

523


Why is xap important?

601


how to elimainte the similar data from the different tables

1707