Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

Structured Query Language - C993 Subqueries

memorize.ai (lvl 286)

(0)

7 cards

()

Section 1

Preview this deck

DELETE with a Correlated Subquery

Front

1 / 7

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

Section 1

(7 cards)

DELETE with a Correlated Subquery

Front

the WHERE clause to determine which rows to delete from a given table

Back

UPDATE with a Correlated Subquery

Front

In the SET clause In the WHERE clause

Back

Single-row subquery

Front

A nested subquery that can return to the outer query only one row of results that consists of only one column. The output of a single-row subquery is a single value.

Back

Subqueries

Front

Nest inside another query Used to compare a single attribute to a list of values

Back

correlated subquery

Front

A subquery that executes once for each row in the outer query.

Back

scalar subquery

Front

A query that returns exactly one value: a single row, with a single column.

Back

Multiple-row subquery

Front

Nested queries that return more than one row of results to the parent query. They are most commonly used in WHERE and HAVING clauses and require multiple-row operators.

Back