Hi,
I need the select Query that gives the result in the order same as the inputs given in 'IN' option.
as
select * from names_table where name in ('pun','lak','nis',trtr)
i need the result in the order as first result of first value then second as second value of IN clause and so on,
i want this to be done in one statement not UNION or UNION ALL and imposingly that the initial physical order is not the same as the inputs provided.
Thanks,
Puneet
Best Regards,
Puneet Sharma - Infosys
Pune, India