Subquery in from clause : Multi column subquery « Query Select « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Query Select
3. Multi column subquery

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.