Advanced SQL

In this section, we discuss the following SQL keywords and concepts:

• SQL UNION
• SQL UNION ALL
• SQL INTERSECT
• SQL MINUS
• SQL Subquery
• SQL EXISTS
• SQL CASE

In addition, we show how SQL can be used to accomplish some of the more complex operations:

• Rank
• Median
• Running Totals
• Percent To Total
• Cumulative Percent To Total