Databases SQL Basics Finding the Data You Want Searching Tables with 'WHERE'

Sung-Fu Han
Sung-Fu Han
3,890 Points
Posted by Sung-Fu Han
Sung-Fu Han
3,890 Points

why the query won't work in task 2 of 3? SELECT * FROM　products WHERE price != 9.99;

why the query won't work? SELECT * FROM　products WHERE price != 9.99;

2 Answers

KRIS NIKOLAISEN
KRIS NIKOLAISEN
54,164 Points
KRIS NIKOLAISEN
KRIS NIKOLAISEN
54,164 Points

That is kind of strange because SQLite in the SQL playground understands !=.

Sung-Fu Han
Sung-Fu Han
3,890 Points
Sung-Fu Han
Sung-Fu Han
3,890 Points

I change the query by eliminate space between "!=".

SELECT * FROM　products WHERE price!=9.99;

And it works.

Maybe there is a bug on treehouse check process.