|
SQL Introduction
This chapter describes what SQL is, and how it can be used.
SQL Select
How to use the SELECT statement to select data from a table in SQL.
SQL Where
How to use the WHERE clause to specify a criterion for the selection.
SQL And & Or
How to use AND and OR to join two or more conditions in a WHERE clause.
SQL Between
How to use BETWEEN....AND to find data in a range.
SQL Distinct
How to use the DISTINCT keyword to return only different values in a column.
SQL Order By
How to use the ORDER BY keywords to return rows in a defined order.
SQL Insert
How to use the INSERT statement to insert new rows into a table.
SQL Update
How to use the UPDATE statement to update or change rows in a table.
SQL Delete
How to use the DELETE statement to delete rows in a table.
SQL Count
This chapter explains how to use the built-in COUNT functions in SQL.
|