SELECT [ { DISTINCT | UNIQUE } | ALL ] { * | select_item [[,] select_item ]... } { into_clause | bulk_collect_into_clause } FROM { table_reference | [ THE ] ( subquery ) } [ alias ] [ { table_reference | [ THE ] ( subquery ) } [ alias ] ]... rest-of-statement ;