See the whole table
Select some columns
Filtering rows
Logic
Text patterns
To be or NULL to be
A little bit of mathematics
Let's practice
Instruction
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 used the inequality sign (!=) to select all users who aren't 18.
Exercise
Select all columns for those cars which weren't produced in 1999.
Stuck? Here's a hint!
Type:
SELECT * FROM car WHERE production_year != 1999;
