Skip to main content

Summary of this Section

At the end of this section, the following key knowledge should be achieved:

selecting specific columns from a table

selecting specific rows from a table using the WHERE clause

sorting the returned rows from a query using the ORDER BY clause

selecting a range of data using the BETWEEN clause

selecting data using the wildcard character % and the LIKE clause

selecting on null columns using the IS NULL and IS NOT NULL clauses

performing calculations and character conversions using the functions:

COUNT counts the number of rows in a table

SUM sum of the values for a named column

MIN minimum value for a named column

MAX maximum value for a named column

AVG average value for a named column

GROUP BY grouping columns before applying a function

HAVING limits the rows returned by the GROUP BY clause

UPPER converts a character string to upper case characters

LOWER converts a character string to lower case characters

defining your own column headings

selecting data from multiple tables

updating data in a table

deleting data from a table.

You have now reached the end of this Outcome. You can return to any topic by using the menu at the left hand side of the screen or return to the Unit home page by clicking on the HNComputing logo near the top left of the screen.