This statement is used to select data from a database
What is a SELECT Statement?
This clause is used to extract only those records that fulfill a specified condition
What is a WHERE Clause?
This function returns the smallest value of the selected column
What is the MIN Function?
This join selects records that have matching values in both tables
What is an INNER JOIN?
This operator is used to search for a specified pattern in a column
How is the LIKE OPERATOR used?
This statement is used to return only distinct (different) values.
What is the SELECT DISTINCT Statement used for?
These operators are used to filter records based on more than one condition
How are the AND, OR and NOT Operators used?
This function returns the largest value of the selected column
What is the MAX Function?
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?
This is used to substitute any other character(s) in a string
What is a Wildcard Character?
This statement is used to insert new records in a table
What is the INSERT INTO Statement used for?
This keyword is used to sort the result-set in ascending or descending order
How is the ORDER BY Keyword used?
This function returns the number of rows that matches a specified criteria
What is the COUNT Function?
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?
This operator allows you to specify multiple values in a WHERE clause
What is the IN OPERATOR?
This statement is used to modify the existing records in a table
What is the UPDATE Statement used for?
A field with no value
What is a NULL Value?
This function returns the average value of a numeric column
What is the AVG Function?
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?
This operator selects values within a given range. The values can be numbers, text, or dates
What is the BETWEEN OPERATOR?
This statement is used to delete existing records in a table
What is the DELETE Statement used for?
This clause is used to specify the number of records to return
How is the TOP Clause used?
This function returns the total sum of a numeric column
What is the SUM Function?
This join is a regular join, but the table is joined with itself
What is a SELF JOIN?
This is used to give a table, or a column in a table, a temporary name
What is an Alias?