SQL Tutorial

SQL-Data Statements

Contents:

• SELECT Statement -- query tables and views in the database
  • SELECT Statement Basics
    • SELECT Clause
    • FROM Clause
    • WHERE Clause
  • Extended Query Capabilities
    • ORDER BY Clause
    • Value Expressions
    • Joining Tables
    • Subqueries
    • Grouping Queries (GROUP BY)
    • Aggregate Queries (Set Functions)
    • Union Queries (UNION)
• SQL Modification Statements
  • INSERT Statement -- add rows to tables
    • VALUES Clause
  • UPDATE Statement -- modify columns in table rows
    • SET Clause
  • DELETE Statement -- remove rows from tables