The not equal sign ( != )

Fantastic! There is one more very important conditional operator, the inequality sign
(!=or sometimes <>).

Look at the example:

SELECT * FROM user WHERE age != 18;

See how easy it is? We've put the inequality sign (!=) to select all users who aren't 18.

Syntax

SELECT * FROM table_name WHERE column_name!= value;


Execute below code

SELECT * FROM car WHERE production_year != 1999 ;

VIN	BRAND	MODEL	PRICE	PRODUCTION_YEAR
LJCPCBLCX14500264	Ford	Focus	8000.00	2005
WPOZZZ79ZTS372128	Ford	Fusion	12500.00	2008
KLATF08Y1VB363636	Volkswagen	Golf	3270.00	1992
1M8GDM9AXKP042788	Volkswagen	Golf	13000.00	2010
1HGCM82633A004352	Volkswagen	Jetta	6420.00	2003