Midterms Flashcards
This clause is used to specify the number of records to return
Limit Clause
This is useful on large tables with thousands of records. Returning a large number of records can impact performance.
Limit Clause
This operator displays a record if all the conditions separated by this operator are true
AND operator
This operator displays a record if any of the conditions separated by this operator is True
Or Operator
This is a function where it returns the smallest value of the selected column
MIN() function
This function returns the largest value of the selected column
MAX() function
This function return the number of rows that matches a specified criterion
COUNT() function
This function returns the average value of a numeric column
AVG() function
This function returns the total sum of a numeric column
SUM() function
This operator is used in a WHERE clause to search for a specified pattern in a column
LIKE operator
What are the two wildcards often used in conjunction with the LIKE operator
Percent Sign - %
Underscore Sign - _
This represents zero, one, or multiple characters
Percent Sign
This represents one, single character
Underscore Sign
True or False:
The percent and underscore sign cannot be used in combinations
False (It can actually used in combinations)
Like Operator Descriptions:
WHERE CustomerName LIKE ‘a%’
Finds any values that start with “a”
Like Operator Descriptions:
WHERE CustomerName LIKE ‘%a’
Finds any values that ends with “a”
Like Operator Descriptions:
WHERE CustomerName LIKE ‘%or%’
Find any values that have “or” in any position
Like Operator Descriptions:
WHERE CustomerName LIKE ‘_r’
Finds any values that have “r” in the second position
Like Operator Descriptions:
WHERE CustomerName LIKE ‘a _ _’
Finds any values that start with “a” and are at least 2 characters in length
Like Operator Descriptions:
WHERE CustomerName LIKE ‘a _ _ _’
Finds any values that start with “a” and are at least 3 characters in length
Like Operator Descriptions:
WHERE CustomerName LIKE ‘a%o’
Finds values that start with “a” and ends with “o”
This character is used to substitute one or more characters in a string
Wildcard character
These characters are used with the LIKE operator.
Wildcard Characters
The LIKE operator is used in a _________ to search for a specified pattern in a column.
WHERE clause
