simulate 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;

Misha (BOB member since 2010-03-15)

2

Please do not cross-post. It leads to fragmented discussions and is against our forum rules. Carry on here.

Jansi :india: (BOB member since 2008-05-12)