Can the IF statement change the output order of the columns in the comparison select

lenyiqing

Hope to output select A.B.C.D-(if B value> C value)
             else select A.C.B.D-(if C> B)

unkmass

Judge by case

lenyiqing

Can you give an example?

lenyiqing

Go up first ...

wgfxman

select A,
(case when B value> C value then B ELSE C END) AS B,
(case when B value> C value then C ELSE B END) AS C, D FROM ..