darma teja

darma teja

  • NA
  • 496
  • 337k

IN clause value list-order by

Aug 20 2014 4:00 AM
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)