SQL

SQL Not Equal to Operator

-- returns records where amount is not equal to 400
SELECT order_id, item, amount
FROM Orders
WHERE amount != 400;

SQL Equal to Operator

-- returns records where customer_id is only 4
SELECT order_id, item, amount
FROM Orders
WHERE customer_id = 4;

SQL Equal to Operator (=)

SELECT *
FROM Customers
WHERE first_name = 'John';