<> (not equal)

Retrieves rows that contain different values from the specified data.

 

Example:

SELECT * FROM Customers_dataflex WHERE customername <> 'Always Open Quick Mart'