# 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”