How to 'Sort' or 'Order By' with the order in the where clause
All,
This could be very basic but I am stuck at a point where I am writing a query having a where clause in it and I need to sort the results in accordance to the where clause.
Here is the query:
select id, status
from consumer
where id IN ('00013716517',
'00001135180',
'00000774955',
'00000364580',
'00004883803',
'00013275296')
How do I make the result appear in order of the 'id' that i have written in the where clause of the query.
Thank you so much in advance.