Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

SQL

memorize.ai (lvl 286)

(0)

20 cards

()

Section 1

Preview this deck

TRUE

Front

1 / 20

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (20)

Section 1

(20 cards)

TRUE

Front

A WHERE clause cannot contain aggregate functions.

Back

ROLLUP, Grouping

Front

You can use the _ function with the __ operator to determine if a summary row has a null value assigned to a given column. Select 2

Back

HAVING, WHERE,

Front

A _ clause can only refer to a column included in the SELECT or GROUP BY clause, whereas the ___ clause can refer to any column in the base tables. Select 2

Back

OVER

Front

Return the individual rows that are used to calculate the summaries along with the summary data using the __________ clause.

Back

summary query

Front

A query that contains one or more aggregate functions is typically referred to as a ________________

Back

False

Front

Coding a search condition in the HAVING clause does Not limit groups included in a result set.

Back

After

Front

When you include a HAVING clause in a SELECT statement, the search condition is applied ____________ the rows are grouped .

Back

Count

Front

Return the number of non-null values in an expression or the number of rows selected by a query using the ___________ aggregate function.

Back

SUM

Front

Sum up all of the non-null values in an expression using the ______________ aggregate function.

Back

ROLLUP

Front

The _______ operator adds a summary row for each group specified. It also adds a summary row to the end of the result set that summarizes the entire result set.

Back

Grouping set

Front

The ______________ operator Only includes summary rows, it Only adds those summary rows for each specified group.

Back

true

Front

All of the aggregate functions Except for COUNT(*) ignore null values.

Back

ORDER BY, Partition By

Front

The __ clause specifies the column that's used to group the results, and the clause specifies the sort order in which a function is applied. Select 2

Back

HAVING

Front

The __________ clause determines which groups are included in the final result set.

Back

Count(*)

Front

If you want to count all of the selected rows, you'll typically use the _____________ function

Back

column functions, column

Front

Because aggregate functions typically operate on the values in a they are sometimes referred to as ___. Select 2

Back

False

Front

To remove duplicate values using COUNT(*), use the DISTINCT keyword to insure only unique values.

Back

Before

Front

When you include a WHERE clause in a SELECT statement that uses grouping and aggregates, the search condition is applied ____________ the rows are grouped and the aggregates calculated.

Back

Group By

Front

If you include two or more columns or expressions in the ____________ clause, they form a hierarchy where each column or expression is subordinate to the previous one.

Back

AVG

Front

Average the non-null values in an expression using the ___________ aggregate function.

Back

SQL

Preview this deck

TRUE

0.0

Cards (20)

TRUE

A WHERE clause cannot contain aggregate functions.

ROLLUP, Grouping

You can use the ___________ function with the ____________ operator to determine if a summary row has a null value assigned to a given column. Select 2

HAVING, WHERE,

A _________ clause can only refer to a column included in the SELECT or GROUP BY clause, whereas the ___________ clause can refer to any column in the base tables. Select 2

OVER

Return the individual rows that are used to calculate the summaries along with the summary data using the __________ clause.

summary query

A query that contains one or more aggregate functions is typically referred to as a ________________

False

Coding a search condition in the HAVING clause does Not limit groups included in a result set.

After

When you include a HAVING clause in a SELECT statement, the search condition is applied ____________ the rows are grouped .

Count

Return the number of non-null values in an expression or the number of rows selected by a query using the ___________ aggregate function.

SUM

Sum up all of the non-null values in an expression using the ______________ aggregate function.

ROLLUP

The _______ operator adds a summary row for each group specified. It also adds a summary row to the end of the result set that summarizes the entire result set.

Grouping set

The ______________ operator Only includes summary rows, it Only adds those summary rows for each specified group.

true

All of the aggregate functions Except for COUNT(*) ignore null values.

ORDER BY, Partition By

The ______________ clause specifies the column that's used to group the results, and the ____________ clause specifies the sort order in which a function is applied. Select 2

HAVING

The __________ clause determines which groups are included in the final result set.

Count(*)

If you want to count all of the selected rows, you'll typically use the _____________ function

column functions, column

Because aggregate functions typically operate on the values in a ______________ they are sometimes referred to as _________________. Select 2

False

To remove duplicate values using COUNT(*), use the DISTINCT keyword to insure only unique values.

Before

When you include a WHERE clause in a SELECT statement that uses grouping and aggregates, the search condition is applied ____________ the rows are grouped and the aggregates calculated.

Group By

If you include two or more columns or expressions in the ____________ clause, they form a hierarchy where each column or expression is subordinate to the previous one.

AVG

Average the non-null values in an expression using the ___________ aggregate function.

You can use the _ function with the __ operator to determine if a summary row has a null value assigned to a given column. Select 2

A _ clause can only refer to a column included in the SELECT or GROUP BY clause, whereas the ___ clause can refer to any column in the base tables. Select 2

The __ clause specifies the column that's used to group the results, and the clause specifies the sort order in which a function is applied. Select 2

Because aggregate functions typically operate on the values in a they are sometimes referred to as ___. Select 2