The SQL SELECT command has many options allowing you to create sophisticated queries of data from the database.
It can, for example:
- select specific rows and columns
- sort the rows returned in ascending or descending order
- perform calculations such as counts, sums and averages
- define your own column headings when displaying results
- select data from multiple tables within the one select command.
In this outcome you will learn many of the options available.