SQL Query for data sorting

Question

pls help me how to write sorting query.i have set of data from my sql query like picture below

Current data sorting are order by level,sequence,chgcode. I want my data be appear by different sorting. which is if level = 2, the sorting will be [order by level,sequence,chgcode,date] other than that will be [order by level,sequence,date,chgcode]

The actual result that i need like picture below

Gordon Linoff · Accepted Answer · 2016-11-22 02:41:45Z

1

This is a little tricky, but you can have multiple keys for the order by:

order by level, sequence,
         (case when level = 2 then chgcode end),
         (case when level = 2 then date end),
         date,
         chgcode

The first two keys are common for both groups. The next two are specific for level = 2 (and in that order); note that the value will be NULL for both when level is not 2. The final two are for everything else.

answered Nov 22, 2016 at 2:41

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Query for data sorting

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related