Deleting 1 and only 1 row from database

Hi,

    I am a novice to Oracle and SQL and I would like to ask you experts for help.

    I have a database that has no primary key defined. The database allows dulplicate records. I want to remove some of the duplicate records so I thought of using "delete", but looking at the syntax, it seems the delete command will delete every matches, which is different from my goal - only the first matched record.

    Can anyone show me the syntax for deleting only 1 record (say, the first match)? Thanks!

Stannon

--
(if you prefer E-mail, please remove "NOSPAM" from my addr)

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own