EasyWHERE & Filtering

Find customers NOT from India

The query

SQL

SELECT name, country, city
FROM customers
WHERE country != 'India' -- or: WHERE country <> 'India'
ORDER BY country;

Tested against PostgreSQL 16

Note

“!= and <> are equivalent. Note: rows with NULL country are also excluded here.