Advanced SQL - Structured Query Language


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



    Copyright © 2013 1keydata.com   All Rights Reserved.     Privacy Policy


    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
    SQL NULL
    SQL ISNULL
    SQL IFNULL
    SQL NVL
    SQL COALESCE
    SQL NULLIF
    SQL Rank
    SQL Median
    SQL Running Totals
    SQL Percent to Total
    SQL Cumulative Percent to Total


    SQL Video Tutorial
    SQL Jobs




    Site Map
    Resources