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
How many disk partitions should I have?
How to run sql functions in pl/sql?
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.
what are the different tables present in mysql? : Sql dba
Is sql considered coding?
Is it mandatory for the primary key to be given a value when a new record is inserted?
What trigger means?
Is not equal in sql?
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
How to take user input in pl sql?
How to use transactions efficiently : transact sql
What are sql data types?
Can you load data into multiple tables at once? : aql loader
Where is sql database stored?
What is the clause we need to add in function body to return variable?