Select first row of duplicate rows?

[rcherch]

Ok..this is going to be fun, now isn't it.

First of all, put a create_dt on the table with a default of sysdate. Make your life easier for the future.

I would look at rownum rank if your running 8.1.6.

select min(rs), emp_nr, last_name,
first_name, prod_cd from
(select rownum rank rs, emp_nr, last_name,
first_name, prod_cd from
(select emp_nr, last_name, first_name, prod_cd,
from fgtab.product_info))
group by emp_nr, last_name, first_name, prod_cd

This might work..