Stuck with what should be simple select query..
Posted by:
Don West
Date: April 03, 2017 09:07PM
Data:
ColA-----ColB
ABC-------36
DEF-------38
ABC-------40
XYZ-------42
DEF-------44
ABC-------46
XYZ-------48
ABC-------50
I want a query result of DISTINCT ColA ORDERED BY ColB ASC.
Result needs to be:
DEF
XYZ
ABC
What query can achieve that??? I am a stumped newbie.
Subject
Written By
Posted
Stuck with what should be simple select query..
April 03, 2017 09:07PM
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.