Wednesday, March 14, 2018

How to populate/retrieve records oracle in customize order?

Scenario:

I have records in the following order:


I need to retrieve the records in the following order:

(i.e., Priority of retrieve records should be based on currency value - 1. USA , 2 . IND 3. SL 4. PAK and 5. BAG)

Query and Output:


No comments:

Post a Comment