not equal to sql code example

Example 1: excel logical not equal

Equal to						=		= A1 = B1	The formula returns TRUE if a value in cell A1 is equal to the values in cell B1; FALSE otherwise.
Not equal to				    <>		= A1 <> B1	The formula returns TRUE if a value in cell A1 is not equal to the value in cell B1; FALSE otherwise.
Greater than					>		= A1 > B1	The formula returns TRUE if a value in cell A1 is greater than a value in cell B1; otherwise it returns FALSE.
Less than						<		= A1 < B1	The formula returns TRUE if a value in cell A1 is less than in cell B1; FALSE otherwise.
Greater than or equal to	   >=		= A1 >= B1	The formula returns TRUE if a value in cell A1 is greater than or equal to the values in cell B1; FALSE otherwise.
Less than or equal to		   <=		= A1 <= B1	The formula returns TRUE if a value in cell A1 is less than or equal to the values in cell B1; FALSE otherwise.

Example 2: 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;

Example 3: not equal operator sql

<> Not Equal

!= Not Equal

Example 4: not equal in sql

row <> value

Tags:

Misc Example