2. Some simple SQL Select statements

Worksheet Overview

The SELECT command is used for all data retrievals and is a very powerful command. This worksheet explores the basic use of select to select data from one table. Further worksheets explore the use of select with multiple tables, to group data and to compute new fields

Contents

1. Demo: Show all Employees
2. Task: Show all Departments
3. Task: Show all Salary Grades
4. Demo: Show selected fields in a table
5. Task: Show the employee name, salary and hiredate
6. Task: Show department locations
7. Demo: Ordering the rows of the output
8. Task: Show employees in salary order
9. Task: Show salary grades in order of the start of the salary band
10. Task: Show salary grades in order of the start of the salary band.
11. Demo: Ordering in Descending order
12. Task: List employee by name, last to be hired first.
13. Read: Worksheet completed

Related worksheets

1. Introduction to the Emp-dept case study
3. Using Functions
4. Selecting ROWS to display
5. Multiple tables
6. Summarising and Grouping
7. Handling Dates
8. Inner and Outer Joins