Having clause

dataservices job design
1

I have a problem to understand how to simulate HAVING clause:

select a, b, c, d, count() count from table
group by a, b, c, d
HAVING COUNT() > 1;

Please help.

Misha (BOB member since 2010-03-15)

2

First query does the group by, second has a where clause in the first query’s count(*) column.

Werner Daehn :de: (BOB member since 2004-12-17)