Re: select count of distinct rows
От | Havasvölgyi Ottó |
---|---|
Тема | Re: select count of distinct rows |
Дата | |
Msg-id | 005501c5fdef$30be34f0$0200a8c0@OTTO обсуждение исходный текст |
Ответ на | unsubscribe ("Dinesh Pandey" <dpandey@secf.com>) |
Ответы |
Re: select count of distinct rows
|
Список | pgsql-sql |
Hi, Yes, I need to compare all fields. Well, in this case it does not. Is this impossible? Thanks, Otto ----- Original Message ----- From: "Jaime Casanova" <systemguards@gmail.com> To: "Havasvölgyi Ottó" <h.otto@freemail.hu> Cc: <pgsql-sql@postgresql.org> Sent: Sunday, December 11, 2005 1:57 AM Subject: Re: [SQL] select count of distinct rows On 12/10/05, Havasvölgyi Ottó <h.otto@freemail.hu> wrote: > Hi, > > I would like to select the count of distinct rows in a table. > > SELECT COUNT(DISTINCT *) FROM mytable; > are really all the fields distincts? the table doesn't have a pk? > This does not work. How can I do it with Postgres? > > Thanks, > Otto > -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
В списке pgsql-sql по дате отправления: