SQL

sql not equal

<>	Not equal. Note: In some versions of SQL this operator may be written as !=

Example sql query:

1) Selecting groceries where price is not 20
SELECT * FROM Grocery WHERE Price <> 20;

not equal operator sql

<> Not Equal

!= Not Equal

SQL Not Equal to Operator

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

not equal in sql

row <> value

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';