Advanced SQL - Structured Query Language

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

• SQL UNION
• SQL UNION ALL
• SQL Inline View
• SQL INTERSECT
• SQL MINUS
• SQL LIMIT
• SQL TOP
• SQL Subquery
• SQL EXISTS
• SQL CASE
• SQL Window Functions
• SQL DECODE
• SQL AUTO INCREMENT
• SQL IDENTITY
• SQL SEQUENCE and NEXTVAL

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

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