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




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