O'Reilly logo

OCA Oracle Database 11g: SQL Fundamentals I: A Real-World Certification Guide by Steve Ries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Putting it all together

In Chapter 2, SQL SELECT Statements, we began with a simple SELECT... FROM statement. We then began adding clauses to accomplish different goals. With the addition of the HAVING clause, we come to the end of the essential clauses used in SELECT statements. While we will still explore other types of SQL statements and the techniques used with them, there are no more new clauses to add to the collection of SQL statements we use to query data. A proper syntax tree that combines all of the clauses for SELECT statements that we have seen throughout this book is shown as follows:

SELECT {column, column, …}
FROM {table}
WHERE {expression}
GROUP BY {expression}
HAVING {expression}
ORDER BY {column};

Nearly every SQL statement we ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required