To: <SauerBL@xxxxxxxxxxxxx>, <Oracle-l@xxxxxxxxxxxxx>
Date: Mon, 20 Dec 2004 14:52:35 -0500
use an analytical
select
c.name.c.assignment
from
(
select
a.name,b.assignment,row_number() over (partition by a.name order by
b.assignment) rnum
from
employee a, gd b
where a.name = b.name
) c
where rnum = 1
--
//www.freelists.org/webpage/oracle-l
