Can you have a "self-defined" ORDER BY
Hi,
I would like to get my results from a query in a specific non-alphabetical order.
Suppose I have a list of addresses. I can get them ordered by city with
"ORDER BY city"
But now I want them to come in a non-alphabetical order (but still ordered by city), say "Amsterdam, Washington, New York".
Is it possible to make a query that gives that result?
Subject
Written By
Posted
Can you have a "self-defined" ORDER BY
May 27, 2018 03:10PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.