The following code provides a breakdown of the basic SELECT statement on the Oracle platform:
SELECT [hint]
[ DISTINCT | ALL ]
<select_list>
FROM <table_reference>
[WHERE <condition>]
[START WITH <condition> CONNECT BY <condition>]
[GROUP BY <elements> ]
[HAVING <condition> ]
[ORDER BY <elements> ]
--