Basic SQL Topics
Not Equal
Sometimes in a dataset, you want to exclude certain data. In the dataset on the top on the right, assume we want to exclude California data. The SQL statement would be:
Option 1:
SELECT *
FROM database_table
WHERE State != ‘California‘
Option 2:
SELECT *
FROM database_table
WHERE State <> ‘California‘
Note Option 1 and Option 2 are almost the exact same — the only difference is using “!=” or “<>” in the query. Either is fine to use, but good to recognize both options in case you come across either one.