Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

Ch. 5: Multiple Table Queries

memorize.ai (lvl 286)

(0)

21 cards

()

Section 1

Preview this deck

EXISTS

Front

1 / 21

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

Section 1

(21 cards)

EXISTS

Front

This operator checks for the existence of rows that satisfy some criterion.

Back

MINUS

Front

This is the operator that creates a temporary table containing the set of all rows that are in the first table but that are not in the second table.

Back

ANY

Front

If a subquery is preceded by this operator, the condition is true only if it satisfies any value (one or more) produced by the subquery.

Back

right outer join

Front

In this join, all rows from the table on the right are included regardless of whether they match rows from the table on the left. Rows from the table on the left are included only if they match.

Back

inner join

Front

This is a join that compares the tables in a FROM clause and lists only those rows that satisfy the condition in the WHERE clause.

Back

union

Front

This creates a temporary table containing every row that is in either the first table, the second table, or both tables.

Back

left outer join

Front

In this join, all rows from the table on the left (the table listed first in the query) are included regardless of whether they match rows from the table on the right (the table listed second in the query). Rows from the table on the right are included only if they match.

Back

outer join

Front

This type of join lists all the rows from one of the tables regardless of whether they match any rows in a second table.

Back

correlated subquery

Front

This type of subquery involves a table listed in the outer query.

Back

nested subquery

Front

This is a subquery within a subquery.

Back

product (Cartesian product)

Front

This is the combination of all rows in the first table and all rows in the second table. (This can be created by eliminating the WHERE clause when attempting to join tables.)

Back

full outer join

Front

In this join, all rows from both tables are included regardless of whether they match rows from the other table. (This join is rarely used.)

Back

INTERSECT

Front

This is the operator that creates a temporary table containing all rows that are in both tables.

Back

difference

Front

This is a temporary table created to contain the set of all rows that are in the first table but that are not in the second table.

Back

intersection

Front

This creates a temporary table containing all rows that are in both tables.

Back

join

Front

Put two tables together by finding rows in the two tables that have identical values in matching columns.

Back

union compatible

Front

Tables are in this state if they have the same number of columns and their corresponding columns have identical data types and lengths.

Back

alias

Front

This is an alternate name used when tables are listed in the FROM clause and can be used the rest of the statement.

Back

self-join

Front

This is when a table is joined to itself.

Back

UNION

Front

The operator used to create a temporary table containing every row that is in either the first table, the second table, or both tables.

Back

ALL

Front

If a subquery is preceded by this operator the condition is true only if it satisfies every single value produced by the subquery.

Back