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.