Subquery in from clause
SQL> SQL> create table myTable 2 as 3 select rownum id, a.* 4 from all_objects a 5 where 1=0 6 / Table created. SQL> SQL> SQL> select * 2 from myTable myTable1, ( select owner, max(last_ddl_time) max_time from myTable group by owner ) myTable2 3 where myTable1.owner = myTable2.owner 4 / no rows selected SQL> drop table myTable; Table dropped.