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
what are the types of subquery? : Sql dba
What is trigger types in sql?
What are the constraints available in sql?
What is pl sql block in dbms?
What are pl sql data types?
How many types of tables are there?
what is not null constraint? : Sql dba
What is compound trigger?
What is out parameter used for eventhough return statement can also be used in pl/sql?
Is a foreign key always unique?
explain advantages of innodb over myisam. : Sql dba
What does fetching a cursor do?
What is parallel hint?
What is the difference between having and a where in sql?
What do you understand by pl/sql records?