Exam 4: Single-Table Queries

The DISTINCT operator is useful when used in conjunction with the COUNT function.

When you query a database, there is a defined order in which the results are displayed.

When you use the ____ function, you can use the asterisk (*)to represent any column.

The inner query in a nested query is called a(n)____________________.

In the SELECT clause, you can use the ____ symbol to indicate that you want to include all columns.

The ____ clause is used to restrict the groups that are included.

The ____ operator is inclusive, meaning that a value equal to either value would be selected.

When you use the SUM function, the column data type must be ____________________.

All SELECT statements require a WHERE clause.

When you need to sort data on two columns, the more important column is called the ____________________ sort key.

The ____ operator finds rows that do not contain a null value in the specified column

In MySQL, you specify the results order by using the ____________________ clause.

It is possible to use both a WHERE clause and a HAVING clause in a SELECT statement.

To specify that query results be listed in a specific order, use the SORT BY clause.

In MySQL, to retrieve character data that exactly matches the case used in a WHERE clause, use the ____ keyword.

You use the ____________________ clause to retrieve rows that satisfy some condition.

You cannot change the order of the columns to be displayed in query results.

The ____ operator specifies a range of values in a condition.

A ____________________ query is one query inside another.

You can use the ____________________ clause to limit the groups that are included.