Standard Statements
Keywords & Values
Functions
Joins
Special Operators
100

This statement is used to select data from a database

What is a SELECT Statement?

100

This clause is used to extract only those records that fulfill a specified  condition

What is a WHERE Clause?

100

This function returns the smallest value of the selected column

What is the MIN Function?

100

This join selects records that have matching values in  both tables

What is an INNER JOIN?

100

This operator is used to search for a specified pattern in a column

How is the LIKE OPERATOR used?

200

This statement is used to return only distinct (different) values.

What is the SELECT DISTINCT Statement used for?

200

These operators are used to filter records based on more than one  condition

How are the AND, OR and NOT Operators used?

200

This function returns the largest value of the selected column

What is the MAX Function?

200

This join returns all records from the left table (table1), and the  matched records from the right table (table2). The result is NULL from the right side,  if there is no match.

What is a LEFT JOIN?

200

This is used to substitute any other  character(s) in a string

What is a Wildcard Character?

300

This statement is used to insert new records in a table

What is the INSERT INTO Statement used for?

300

This keyword is used to sort the result-set in ascending or  descending order

How is the ORDER BY Keyword used?

300

This function returns the number of rows that matches a specified criteria

What is the COUNT Function?

300

This join returns all records from the right table (table2), and the  matched records from the left table (table1). The result is NULL from the left side,  when there is no match.

What is a RIGHT JOIN?

300

This operator allows you to specify multiple values in a WHERE clause

What is the IN OPERATOR?

400

This statement is used to modify the existing records in a table

What is the UPDATE Statement used for?

400

A field with no value

What is a NULL Value?

400

This function returns the average value of a numeric column

What is the AVG Function?

400

This join returns all records when there is a match in  either left (table1) or right (table2) table records

What is a FULL OUTER JOIN?

400

This operator selects values within a given range. The values can be numbers, text, or dates

What is the BETWEEN OPERATOR?

500

This statement is used to delete existing records in a table

What is the DELETE Statement used for?

500

This clause is used to specify the number of records to return

How is the TOP Clause used?

500

This function returns the total sum of a numeric column

What is the SUM Function?

500

This join is a regular join, but the table is joined with itself

What is a SELF JOIN?

500

This is used to give a table, or a column in a table, a temporary name

What is an Alias?

M
e
n
u