On Feb 21, 2008, at 3:41 PM, Uwe Grauer wrote:
> Please try:
> select entity_type, entity_fk, count(*) as ent_count from
> assignment_rotation
> group by entity_type, entity_fk
> having count(*) > 1
Of course, but that's not the question.
The only reason for the 'having' clause is to be able to operate on
the result set so that aggregate columns that don't exist in the
sources can be filtered. The result set should have knowledge of
'ent_count' at that point (i.e., it works in the 'order by' clause).
-- Ed Leafe
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/dabo-users/[EMAIL PROTECTED]
