oreilly_getting_started_with_sql
oreilly_getting_started_with_sql copied to clipboard
thomasnield
Syntax doesn't work as expected
On page 51 the author introduces an example of COALESCE() function. But it doesn't work. I mean, there are still NULL fields. Here is the statement:
SELECT * FROM station_data
WHERE coalesce(precipitation, 0) <= 0.5;
