Re: SQL CORR SUBQUERY EXPERTS

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