File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Oracle/OAS and the fly likes joins and rollup Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "joins and rollup" Watch "joins and rollup" New topic
Author

joins and rollup

rama rajesh
Greenhorn

Joined: Jun 22, 2010
Posts: 28
How to identify which is a subquery and which is correlate subquery?i understand the difference between correlated subquery and subquery
(got information like subqeury executed only one and correlated subquery executes several times)

i read the rollup function, but i can't understand the functionality.
if anybody knows, please explain with simple example(rollup by more than 2 columns)
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: joins and rollup
 
Similar Threads
SQL question
A Tricky Stored Procedure
joins
Help with a Query!!!!
retrieve data from huge result set