LESSON 22Creating Complex SQL Queries
This lesson discusses, mostly by example, complex queries. Complex queries are an everyday part of life for the SQL programmer. Many of this lesson’s examples may prove to be useful to you, as many are real examples that we have actually used. By the end of the lesson, you should understand
• How SQL commands interact with each other
• How functions, expressions, and operators can be used together
• How to use complex arithmetic combinations in the SELECT clause
• How to formulate complex queries on your own
Get Sams Teach Yourself SQL in One Hour a Day, Fifth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
