SQL - 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