Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DISTINCT and ORDER BY

401855Jul 16 2004 — edited Oct 31 2008
SELECT DISTINCT fname, lname
FROM employee
ORDER BY job_id;

For this to work job_id has to be part of the SELECT expression, but i'd like to know why since i readily can't see any reason.

Regards
Fergus
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 28 2008
Added on Jul 16 2004
#order
12 comments
17,313 views