SQL · Joins and set operations

except

Rows in the first result set that are not in the second.

sqlRunnable example sql course

Syntax

select … except select …

Example

Open in the lab

SELECT 'HTML' AS title EXCEPT SELECT 'CSS';

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.