4
Answers

IN clause value list-order by

darma teja

darma teja

10y
708
1
Hi All,

My query is: select name from customer where id (1, 5, 3, 2);

The result I am getting  is descending order of id like this:
        1        a
        2        b
        3        c
        5        d

How can I get order by my specific values in id list like this:

        1        a
        5        d
        3        c
        2        b

Thanks! 
Darma

Answers (4)