Database - Introduction to SQL

DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.

The result of every SQL query is a table.

COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.

SUM, AVG, MIN, and MAX can only be used with numeric columns.

Most companies keep at least two versions of any database they are using.