greater than or equal to
used to define range limits
used to check whether an attribute value matches a value contained within a (sub)set of listed values
used to check whether an attribute value is null
used to check whether an attribute has a value.
used to check for similar character strings
matches any number of characters. it can be used as the first or last character in the character string
matches any single alphabetic character
joins two or more conditions and returns results when all are true
joins two or more conditions and returns results when any are true
negates an expression
lists in sequence
gives the total of all rows, satisfying any condition, of the given column
gives the average of the given column
gives the largest figure in the given column
gives the smallest figure in the given column
gives the number of rows satisfying the condition
counts the number of rows
returns today's date
returns only the year from a date field
rounds to the nearest whole number
indicate columns to summarize on
indicate group conditions
omits records that contain duplicate data in the selected fields
format used to identify an attribute of a table when tables being joined have attributes of the same name
& ' ' &
to combine two attributes into a single column
query inside a query. use in WHERE and HAVING conditions
Please allow access to your computer’s microphone to use Voice Recording.
We can’t access your microphone!
Click the icon above to update your browser permissions and try again
Reload the page to try again!
Press Cmd-0 to reset your zoom
Press Ctrl-0 to reset your zoom
It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.
Your microphone is muted
For help fixing this issue, see this FAQ.