oracle order by problemgreenspun.com : LUSENET : DBAzine : One Thread
I've got a problem with order by clause in oracle. I have to order the result of a query like this: select col1, col2, col3 from table order by col1='value1', col2; so the first lines of the results will be the rows, where col1 = 'value1'. It works in mysql, postgresql, etc, but it doesn't work in oracle...
Is it possible some way?
Thanks in advance, Csaba
-- Csaba Sólya (firstname.lastname@example.org), April 24, 2004