[SQL] select count of distinct rows

Sat, 10 Dec 2005 16:54:06 -0800

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

Reply via email to