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

What are the difference between Functions/Stored Procs and Triggers and where are they used.

1 Answers   CGI, TCS,

What does select count (*) mean in sql?

0 Answers  

Which is the correct statement about truncate and delete?

0 Answers  

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

0 Answers  

What is natural join in sql?

0 Answers  




What are transaction and its controls?

0 Answers  

What is a sql statement?

0 Answers  

what are the different index configurations a table can have? : Sql dba

0 Answers  

Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --

5 Answers  

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

0 Answers  

Which sql most popular?

0 Answers  

How to add, remove, modify users using sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories