3. Interrogate the Database and Manipulate the Data

Table of Contents

1. Data Manipulation Language
   1. SELECT Command
   2. Columns and Rows
   3. Comparison Operators
   4. SELECT examples
   5. Sorting Returned Rows
   6. Activity 3.1
   7. Answer to Activity 3.1
   8. Multiple Tables
   9. Links Between Tables
   10. Using an Alias
   11. Other Conditions
   12. LIKE Clause
   13. IS NULL Clause
   14. DISTINCT
   15. Activity 3.2
   16. Answer to Activity 3.2
2. Performing Calculations
   1. GROUP BY Clause
   2. HAVING clause
   3. Column Headings

(c) 2007 Scottish Qualifications Authority