Re: Problem with select statement for duplicate data

Machiel Richards wrote:
>> select column1,column2,column3,count() from table
>> group by column1,column2,column3 having count()>  1;
>>
>>  This however gives me the following error:
>>
>> ERROR: count(*) must be used to call a parameterless
>> aggregate function

Jayadevan M wrote:
> Shouldn't it be count(*)?
> select column1,column2,column3,count(*).......having count(*)>  1

That's what the error message says.  It gives the solution in the report of
the problem.

--
Lew
Ceci n'est pas une pipe.