hi, i have a query for example "select * from table where id in (13,19,17,16,25)". i want the resulting rows in the order given in "in section". Is this possible?? Shankar.
Joined: May 10, 2001
i just changed my query and using preparedstatement thereby able to restore the order i had asked for. hope the difference is not much when it comes to performance.anyways i would like to know if using a single select and "in", is it possible to restore the order given in the "in"... shankar.
Joined: Aug 18, 2003
Hi Shankar In oracle, it is possible to achieve that through a single select statement. You have to write a decode function in your order by clause. I am not sure about the other databases. Thanks -Sainudheen