Use DUAL-Function to define the sort-order

[#1]

Hello Community,

can someone please help me to use the DUAL-Function to sort the columns Col1 and Col2 in the script?



I want this solution:



A      big          x

A     small   a

A     big        y

A     small     z

B     big     c

B   small   b

C   big     d





Important is the sort-order at Col1 and Col2. So after "big" should come "small".

the qv-file is attached.

Thanks! best regards, aylin

[swuehl · Accepted solution]

Maybe like attached?

Stefan

[#3]

Thank you Stefan. It works.