11. SQL Essentials & Advanced Flashcards by Tom Burgoyne

Q

UNION

A

Everything but excluding duplicates

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

UNION ALL

A

Everything including duplicates

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

INTERSECT

A

Only the duplicates

How well did you know this?

1

Not at all

2

3

4

5

Perfectly