Hi,
Is there a way to order the result set to display in the same order as data supplied in IN clause
example:
select * from t_cu where cno IN (
220,
120,
900,
350,
99,
1,
34
);
I would like to display the data in the same order as
220,
120,
900,
350,
99,
1,
34
I know this can be done using UNION ALL, however if 50+ records are there in the IN clause, then it is quite a task.
Thanks