> >>> select count(distinct(row)) from table;
hi,
I have also tried but I am geting an error.
***************
tempdb=> \d tbltemp
Table = tbltemp
+----------------------------------+----------------------------------+-----
--+
| Field | Type |
Length|
+----------------------------------+----------------------------------+-----
--+
| id | int4 |
4 |
| name | varchar() |
40 |
+----------------------------------+----------------------------------+-----
--+
tempdb=> select count(distinct(row)) from tbltemp;
ERROR: parser: parse error at or near "distinct"
tempdb=>
***************
Thanks
Anuj
-----Original Message-----
From: pgsql-general-owner@hub.org [mailto:pgsql-general-owner@hub.org]On
Behalf Of sridhvenk@yahoo.com
Sent: Wednesday, August 23, 2000 9:12 AM
To: J. Atwood
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Count & Distinct
It works fine. Please try again
On Wed, 23 Aug 2000, J. Atwood wrote:
> Search a lot of archives and have come up with very little (much old)
>
> obviously
>
> >>> select count(distinct(row)) from table;
>
> Does not work so what is the work around? I have tried a bunch of stuff.
>
> Thanks,
> J
>
>