Skip to content
Advertisement

How to select data that doesn’t exist in other query

I’m trying to select from table data but i want the result not exist in this select.

So there are no row that been selected double.
Fiddle with sample data.

Advertisement

Answer

With NOT EXISTS:

See the demo.

User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement