Selecting Distincts

I've got a problem that I'm trying to solve. Say I have a table as follows:
emp

emp_id
emp_dept
emp_name
emp_desc

How can I get all columns where distinct (emp_id and emp_dept), ie select *
from emp
where distinct (emp_id and emp_dept)

Any help/insights appreciated.

Thanks

mkb Received on Thu May 06 1999 - 11:53:25 CDT