maintain result set order with WHERE IN clause
How to make the result match the order in a WHERE IN clause?
SELECT * FROM tbl_name WHERE column_a IN ( val1, val2, val3 );
The result set that has column_a equal to val1 will precede all result with column_a equal to val2, and in turn precede column_a equal to val3.
Can I do that? Thanks.
Subject
Views
Written By
Posted
maintain result set order with WHERE IN clause
9077
May 23, 2008 04:15PM
4693
May 23, 2008 08:26PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.