EXCEPT

SQL에서 데이터 조인하기

Maham Faisal Khan

Senior Content Developer, DataCamp

EXCEPT 벤 다이어그램

An image that shows three Venn diagrams, with two faded out. Only the diagram with UNION is in focus. The UNION diagram has two overlapping circles, fully covered in green.

SQL에서 데이터 조인하기

EXCEPT 다이어그램

A diagram showing two tables, left and right. On the right side of the diagram, there is an illustration of what happens when a UNION operation is performed on the two tables.

SQL에서 데이터 조인하기

EXCEPT 구문

SELECT monarch, country
FROM monarchs
EXCEPT
SELECT prime_minister, country
FROM prime_ministers;
|------------------|------------------|
| monarch          | country          |
|------------------|------------------|
| Harald V         | Norway           |
| Charles III      | United Kingdom   |
| Willem-Alexander | Netherlands      |
|------------------|------------------|
SQL에서 데이터 조인하기

연습해봅시다!

SQL에서 데이터 조인하기

Preparing Video For Download...