joins and rollup

[rama rajesh]

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)