Re: SQL CORR SUBQUERY EXPERTS
From: <roosens>
Date: 1996/07/29
Message-ID: <4th01g$1uc4_at_news-s01.ny.us.ibm.net>#1/1
Date: 1996/07/29
Message-ID: <4th01g$1uc4_at_news-s01.ny.us.ibm.net>#1/1
Hi,
The where-clause on group-functionalities should be placed in the having-clause
Your statement would have to look like :
SQL> l
1 select table_name,count(*)
2 from sys.dba_constraints 3 group by table_name 4* having count(*) >= 7
Hoping to be of service
Greetings,
ir Danny Roosens
Belgium
Received on Mon Jul 29 1996 - 00:00:00 CEST