You will have to forgive me I am new to this, but I want to be able to do a select distinct based on ID number, but display all information from the table just not the duplicate entries. This is what I have but obiviously doesn't work.
select * from emp
where id = (select distinct id from emp)
order by last_name
Cann someone help the new guy out?
THanks in advance
Posting the table structure could help ...
One thing: if "select distinct id from emp" returns more than one value you should use
"select * from emp
where id IN (select distinct id from emp)
order by last_name"
SELECT DISTINCT id, field1, field2, field3, field4
FROM table
GROUP BY id
ORDER BY last_name