You could use:
select * from mytable where rowid in (select min(rowid) from mytable group by emp);
Of course, this doesn't guarantee any certain order, but merely A record for each employee. Without a date/time stamp, there's no way to do it.
|
Results 1 to 8 of 8
Threaded View
|
Click Here to Expand Forum to Full Width |