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 }

Answers were Sorted based on User's Feedback



How do you retrieve set of records from database server. {Set max records = 100 & use paging ..

Answer / pandu

Hi the above posted Querry is wrong


this is Correct

Select * from TableName
where rowid in(
Select rowid from TableName
where rownum =&upto(EX <=100,200
minus
select rowid from TableName
where rownum<=&from(EX =1,101)
)

Is This Answer Correct ?    8 Yes 2 No

How do you retrieve set of records from database server. {Set max records = 100 & use paging ..

Answer / padma

select top 100 * from <tablename>

Is This Answer Correct ?    0 Yes 7 No

Post New Answer

More SQL PLSQL Interview Questions

What is scalar and vector?

0 Answers  


How can we schedule the procedure to run automatically ?

3 Answers  


What is full form of rtm?

0 Answers  


Is ms sql traffic encrypted?

0 Answers  


How do you remove duplicates without using distinct in sql?

0 Answers  






How can I make sql query run faster?

0 Answers  


Which is better cte or subquery?

0 Answers  


How many triggers can be applied to a table?

0 Answers  


what is an extent ? : Sql dba

0 Answers  


how do you login to mysql using unix shell? : Sql dba

0 Answers  


Can we rollback delete command?

0 Answers  


How to get each name only once from an employee table?

0 Answers  


Categories