Hello,
I've been trying to find a way, using Oracle Express, to return more than one column but have only one column be distinct. The following will make all three columns distinct. I want only the Job_ID column to be distinct. Can this be done in Oracle?
SELECT DISTINCT Job_ID, Employee_ID, Last_Name
FROM Employees
ORDER BY Last_Name
Thanks Much,
Lewis