Advanced SQL

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 DECODE
  • SQL AUTO INCREMENT
  • SQL IDENTITY
  • SQL SEQUENCE and NEXTVAL

    • The concept of NULL is uniquely important in SQL. Hence, we include a section on the use of NULL, as well as NULL-related functions:

  • SQL NULL
  • SQL ISNULL Function
  • SQL IFNULL Function
  • SQL NVL Function
  • SQL Coalesce Function
  • SQL NULLIF Function

    • 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
    • Next: SQL UNION

    Site Map   |   Resources