home *** CD-ROM | disk | FTP | other *** search
/ NetNews Usenet Archive 1993 #3 / NN_1993_3.iso / spool / comp / database / oracle / 2955 < prev    next >
Encoding:
Text File  |  1993-01-26  |  599 b   |  22 lines
  1. Newsgroups: comp.databases.oracle
  2. From: smj@jbecpor.demon.co.uk (Martin Jarvis)
  3. Path: sparky!uunet!pipex!demon!ALPHA!smj
  4. Subject: Re: Q: Duplicate records
  5. Organization: John Brown E&C Ltd
  6. X-Newsreader: Tin 1.1 PL4
  7. References: <1993Jan23.124513.26942@kaija.spb.su>
  8. Apparently-To: mail2news@news.demon.co.uk
  9. Date: Mon, 25 Jan 1993 17:42:48 +0000
  10. Message-ID: <C1F7vC.Huu@jbecpor.demon.co.uk>
  11. Sender: usenet@demon.co.uk
  12. Lines: 8
  13.  
  14. Oracle's Technical Bulletin, March 1992
  15.  
  16. DELETE FROM tablename
  17.  WHERE ROWID NOT IN 
  18.      ( SELECT MAX(ROWID) FROM tablename
  19.         GROUP BY keycolumn1, keycolumn2, etc )
  20.  
  21.  
  22.