Find out duplicate keys

Hi all,

        I wonder if there is a easier way to delete the rows with duplicate keys (including single PK and composite PKs) without using resursion or alias of the table.

        Thanks for your help.

Vito Kwan
vkwan_at_dorsai.org

-- 
Vito Kwan
vkwan_at_dorsai.org
======================================================================
I am Sir Oracle, And when I ope my lips, let no dog bark!
                               Shakespeare: The Merchant of Venice