Home > mailing lists

select count of distinct rows - Mailing list pgsql-sql

From	Havasvölgyi Ottó
Subject	select count of distinct rows
Date	December 10, 2005 23:53:42
Msg-id	003001c5fded$53a2c5a0$0200a8c0@OTTO Whole thread Raw
In response to	unsubscribe ("Dinesh Pandey" <dpandey@secf.com>)
Responses	Re: select count of distinct rows Re: select count of distinct rows Re: select count of distinct rows
List	pgsql-sql

Hi,

I would like to select the count of distinct rows in a table.

SELECT COUNT(DISTINCT *) FROM mytable;

This does not work. How can I do it with Postgres?

Thanks,

Otto

From: "Leif B. Kristensen"
Date: 10 December 2005, 09:07:49
Subject: Re: Error from trigger

From: Jaime Casanova
Date: 10 December 2005, 23:57:11
Subject: Re: select count of distinct rows