[[SQL Concepts]]

DISTINCT(result_field)

Used within the SELECT clause, DISTINCT will cause the defined field to be displayed only once. Enforces unique records.

COUNT(result_field)

Used in the SELECT clause, COUNT will count all defined rows. This is usually only used with the ’*’ as the field; this is so that it will count every row. Always aliased.

CONCAT(value + ‘string’)

Used in the SELECT clause to refer to one or many described values into one. Most commonly used to select things such as “lastName” and “firstName” to create a “whole name” field. Simply concatenates results together

MAX(field)

Used in the SELECT clause to find the MAXIMUM value within the defined field.

MIN(field)

Used in the SELECT clause to find the MINIMUM value within the defined field.

SUM(field)

Used in the SELECT clause to find the SUM of the defined field.

AVG(field)

Used in the SELECT clause to find the AVG of the defined field.