In SQL in order to avoid getting a NULL value, I can use the "coalesce" function to substitute it like so:
SELECT COALESCE(some_column, 0) FROM some_table;
But I can't find any way to do the same thing using Sequel.
DB[:some_table].select{coalesce(some_column, 0)}
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With