1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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 }

Question Posted / hemanth desai

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

How to add a column ‘salary’ to a table employee_details?

0 Answers  

how many values can the set function of mysql take? : Sql dba

0 Answers  

What is pivot in sql?

0 Answers  

Explain foreign key in sql?

0 Answers  

what are properties of a transaction? : Sql dba

0 Answers  




What is a package ? What are the advantages of packages ?

2 Answers   Symphony,

Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.

3 Answers   JPMorgan Chase,

What is a transaction?

5 Answers  

Show the cursor attributes of pl/sql.

0 Answers  

What is pl sql quora?

0 Answers  

how does a local variable is defined using t-sql? : Transact sql

0 Answers  

how to findout the 100th maximum salary

28 Answers   Amdocs,

For more SQL PLSQL Interview Questions Click Here
Categories