SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Order by Problem in Rollup

757161Mar 2 2010 — edited Mar 5 2010

Hi

I have sorting problem, when i use rollup function to calculate sub total .

select region,country,port_id,sum(quantity) from Port_Dtl
group by rollup(region,country,port_id)

In the above query, i want to sort the result by Port_id ascending.

Any idea?

This post has been answered by 636391 on Mar 4 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 2 2010

Added on Mar 2 2010

#in, #order, #problem

16 comments

1,625 views