select rowName,count(1) from table group by rowName having count(1)>1 On Wed, Nov 10, 2010 at 9:06 AM, Khangelani Gama < khangelani.g...@ucs-software.co.za> wrote:
> Hi all > > > > I am looking for a PostgreSQL Select command that will list me only > duplicate rows. > > > > I am using psql 8.4.4.10 > > > > > > Thanks in advance > > > > > > > > ** > > > > > > Confidentiality Notice:http://ucs.co.za/conf.html > > > > > > ------------------------------ > The contents of and attachments to this e-mail are intended for the > addressee only, and may contain the confidential information of UCS Group > and/or its subsidiaries. Any review, use or dissemination thereof by anyone > other than the intended addressee is prohibited. If you are not the intended > addressee please notify the writer immediately and destroy the e-mail. UCS > Group Limited and its subsidiaries distance themselves from and accept no > liability for unauthorised use of their e-mail facilities or e-mails sent > other than strictly for business purposes. > -- --------------------------------------- Viktor Bojović --------------------------------------- Wherever I go, Murphy goes with me
