It's not a secret anymore!
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
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "joins and rollup" Watch "joins and rollup" New topic

joins and rollup

rama rajesh

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:
subject: joins and rollup
It's not a secret anymore!