Generic SQL: SELECT LASTNAME,FIRSTNAME,COUNT(*) FROM TABLENAMEHERE ORDER BY LASTNAME,FIRSTNAME GROUP BY LASTNAME,FIRSTNAME HAVING COUNT(*)>1
--- Tito Mari Francis Escaño <[EMAIL PROTECTED]> wrote: > Pls provide me pointers how to determine via SQL if > a PostgreSQL > record has a duplicate entry. > > For example, in a database, in record 1, there's > firstname and > lastname entry of 'Juan dela Cruz', and on record N, > there's again > firstname and lastname entry of 'Juan dela Cruz'. > > Thanks in advance. > > -- > Tito Mari Francis H. Escaño > Computer Engineer and Free Software Proponent > _________________________________________________ > Philippine Linux Users' Group (PLUG) Mailing List > [email protected] (#PLUG @ irc.free.net.ph) > Read the Guidelines: http://linux.org.ph/lists > Searchable Archives: http://archives.free.net.ph > _________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List [email protected] (#PLUG @ irc.free.net.ph) Read the Guidelines: http://linux.org.ph/lists Searchable Archives: http://archives.free.net.ph
