Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Query Select

 

Subquery with comparison operator

SQL> SQL> SELECT COUNT(*) num_owned, a.owner   2      FROM dba_objects a   3      WHERE 100<(SELECT COUNT(*) FROM dba_objects b   4      WHERE a.owner=b.owner)   5      GROUP BY a.owner;  NUM_OWNED OWNER ---------- ------------------------------        473 MDSYS       1143 FLOWS_020100       2769 PUBLIC        575 RNTSOFT        339 CTXSYS        449 SYSTEM        668 XDB       6631 SYS 8 rows selected.