Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

Chapter 4 MySQL

memorize.ai (lvl 286)

(0)

35 cards

()

Section 1

Preview this deck

IS NULL

Front

1 / 35

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 (35)

Section 1

(35 cards)

IS NULL

Front

special operator that specifies null values for a column in a query

Back

NOT

Front

logical operator that reverses the truth of the original condition

Back

computed column

Front

A column that does not exist in the database but can be computed using data in existing columns

Back

FROM clause

Front

The clause that indicates the table from which to retrieve the specified columns

Back

key

Front

The column on which data is to be sorted when the ORDER BY clause is used

Back

AND

Front

logical operator that connects simple conditions and requires all conditions to be true for the compound condition to be true

Back

major sort key

Front

The more important column when data on two columns needs to be sorted

Back

IN clause

Front

The clause that consists of the IN operator, the operator which finds a value in a group of values specified in the condition

Back

AVG

Front

function that calculates the average value in a numeric range

Back

IN

Front

special operator which finds a value in a group of values specified in the condition

Back

DESC

Front

operator included in an ORDER BY clause when results are to be sorted in descending order

Back

GROUP BY clause

Front

The clause that groups rows based on the specified column

Back

WHERE clause

Front

The clause that specifies any conditions for the query

Back

primary sort key

Front

The more important column when data on two columns needs to be sorted

Back

DISTINCT

Front

operator that eliminates duplicate values in the results of a query

Back

aggregate function

Front

Special SQL functions that apply to groups of rows and used to calculate sums, averages, counts, maximum values, and minimum values

Back

compound condition

Front

A condition formed by connecting two or more simple conditions

Back

COUNT

Front

function that counts the number of rows in a table

Back

HAVING clause

Front

The clause that limits a condition to the groups that are included

Back

simple condition

Front

A condition that has the form: column name, comparison operator, and either another column name or a value

Back

BETWEEN

Front

special operator that specifies a range of values in a condition

Back

subquery

Front

The inner query in nested queries

Back

minor sort key

Front

The less important column when data on two columns needs to be sorted

Back

MAX

Front

function that calculates the maximum value in a numeric range

Back

grouping

Front

Creates groups of tows that share some common characteristic

Back

OR

Front

logical operator that connects simple conditions; compound condition will be true whenever one of the simple conditions is true

Back

ORDER BY clause

Front

The clause that allows query results to be sorted in a specified order

Back

IS NOT NULL

Front

special operator used to specify no null values for a column in a query

Back

sort key

Front

The column on which data is to be sorted when the ORDER BY clause is used

Back

SELECT clause

Front

The clause that specifies the columns to retrieve in the query

Back

secondary sort key

Front

The less important column when data on two columns needs to be sorted

Back

SUM

Front

function that sums numeric values in a range

Back

query

Front

A question represented in a way that the DBMS can understand

Back

LIKE

Front

special operator that uses one or more wildcard characters to test for a pattern match

Back

MIN

Front

function that calculates the minimum value in a numeric range

Back