Hi all,
I have an sql to retrieve some data. the format of the query is like,
select field1,field2 from tablename where field1 in(1,2,3);
This is fine and it returns the details correctly.
It gives result in the ascending order of what i give in the "in"
ie. even if I give like
select field1,field2 from tablename where field1 in(3,1,2);
then also it's returning the results based on 1,2,3 order.
I want the order not to be in ascending or descending but in the
same order as i give in where condition.
please help...
Thanks and Regards,
sand...