Re: FW: Count & Distinct

anuj wrote:
>
> > >>> select count(distinct(row)) from table;
> hi,
> I have also tried but I am geting an error.
>

It's true that you get an error from trying to execute the query above;
'distinct' is not a function but a keyword, count() is a agregate
function. Following this the correct notation for your query would be:

select count(distinct <row>) from <table>;

I tested this on postgreSQL 7.02 and it works.

I tried this:

NAW=# \d tmpTable
Table "tmptable"
Attribute | Type | Modifier
-----------+-------------+----------
id | integer |
name | varchar(25) |

NAW=# select * from tmpTable;
id | name
----+-----------
1 | Jansen
2 | Jansen
3 | Pietersen
4 | Pietersen
(4 rows)

NAW=# select count(name) from tmpTable;
count
-------
4
(1 row)

NAW=# select count(distinct name) from tmpTable;
count
-------
2
(1 row)

Success and kind regards,

Nils Zonneveld
--
"Misschien is niets geheel waar, en zelfs dat niet"
Multatuli (Eduard Douwes Dekker) - Idee 1