where not in array sql 1

where not in array sql

SELECT * FROM albums WHERE name NOT IN ('Wall', 'Profile', 'Cover', 'Instagram')

Here is what the above code is Doing:
1. We’re selecting all the columns from the albums table.
2. We’re filtering the results to only include albums whose name is not in the list of strings.

Similar Posts