removing duplicate records

From: Ivan Chow <ichow2_at_hotmail.com>
Date: Thu, 05 Aug 2004 13:01:16 -0400
Message-ID: <BAY12-F2JJwj0EuwVZn00016e1d@hotmail.com>

Hi,
I'm not sure how I can achieve this in one SQL statement. I want to remove duplicate id's from the following table.

SQL> select * from emp;

ID FIRST LAST
---------- ---------- ----------

         1 MIKE       SMITH
         1 SUE        GAINER
         1 DEB        SHELLY
         2 JOHN       BAKER
         3 DAN        DOE
         3 MIKE       DOE

6 rows selected.

The results after removing the duplicates:

ID FIRST LAST
---------- ---------- ----------

         1 MIKE       SMITH
         2 JOHN       BAKER
         3 DAN        DOE

For each duplicate id, it does not matter which id I retain. It can be MIKE SMITH or SUE GAINER or DEB SHELLY.

thanks.

Ivan

FREE pop-up blocking with the new MSN Toolbar – get it now! http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Thu Aug 05 2004 - 11:57:05 CDT