Re: order by question

On Fri, Jun 19, 2009 at 6:50 AM, Tony Liao <tonyliao(at)yuehetone(dot)com> wrote:
Hi,All
for example,I have a query as this
select id,product_id from table_name where product_id in
(6,3,4,10,7) order by .....
the results I want to get as bellow:
id................product_id......................
33...............6...................................
40...............6..................................
12...............3....................................
25...............4.................................
10...............4................................
17...............10.................................
43................7...................................

any Idea? thanks

--
Tony Liao

I suppose you want order by IN condition "(6,3,4,10,7)" (?)

Sergio Gabriel Rodriguez
http://www.3trex.com.ar