Обсуждение: PostgreSQL Select command that will list only duplicate rows

Поиск
Список
Период
Сортировка

PostgreSQL Select command that will list only duplicate rows

От
Khangelani Gama
Дата:

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.

Re: PostgreSQL Select command that will list only duplicate rows

От
Viktor Bojović
Дата:
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.Gama@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