Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How do you retrieve set of records from database server.

{Set max records = 100 & use paging where pager page no or
records = 10 & after displaying 100 records again connect to
database retrieve next 100 }

Answer Posted / padma

select top 100 * from <tablename>

Is This Answer Correct ?    0 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many disk partitions should I have?

992


How to run sql functions in pl/sql?

1060


in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2087


what are the different tables present in mysql? : Sql dba

988


Is sql considered coding?

1050


Is it mandatory for the primary key to be given a value when a new record is inserted?

1201


What trigger means?

997


Is not equal in sql?

1018


Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

998


How to take user input in pl sql?

1168


How to use transactions efficiently : transact sql

1062


What are sql data types?

1034


Can you load data into multiple tables at once? : aql loader

1075


Where is sql database stored?

988


What is the clause we need to add in function body to return variable?

1015