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 two columns

Khalil DahhamApr 12 2019 — edited Apr 12 2019

Hello,

I have the following table:

Col1	Col2
1	A
2	B
3	C
4	A
5	B
6	C

I want it ordered as follows:

Col1	Col2
6	C
3	C
5	B
2	B
4	A
1	A

So what I want is to sort by Col1 descending, but with Col2 values grouped together. How to do this in SQL?

This post has been answered by Mustafa KALAYCI on Apr 12 2019

Jump to Answer

Added on Apr 12 2019

4 comments

1,287 views