Advanced SQL


  SQL > Advanced SQL

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

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 SQL can be used to accomplish some of the more complex operations:

    SQL UNION >>

    Site Map   |   Resources



    Copyright 2010 1keydata.com.   All Rights Reserved.     Privacy Policy  


    SQL UNION
    SQL UNION ALL
    SQL INTERSECT
    SQL MINUS
    SQL LIMIT
    SQL TOP
    SQL Subquery
    SQL EXISTS
    SQL CASE
    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 Jobs




    Site Map
    Resources




    Data Warehousing & Business Intelligence



    Deutsch-SQL Tutorial

    Traditional Chinese

    Simplified Chinese