Skip to Main Content
Forums

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!

Group by preserving the order

jeneeshNov 29 2006 — edited Jan 5 2011

Say for eg: my data is like this

--order by col3
col1 col2  col3
1       5     1
1      10    2
2      2      3 
2      5      4
1     15     5
I hav to get o/p as
col1  sum_col2
1       15
2       7
1      15
I have to group by preserving the order
Pls give me suggestions..

jeneesh

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 2 2011
Added on Nov 29 2006
9 comments
14,099 views