Sql

SELECT IFNULL(Price, 0) FROM Products;
SELECT COALESCE(Price, 0) FROM Products;
-- Oracle (extra):
SELECT NVL(Price, 0) FROM Products;

PREVIOUS	NEXT

Code Example
Sql :: how to print longest name in sql
Sql :: row number mysql
Sql :: set auto increment to 1 mysql
Sql :: postgres make sql dump
Sql :: Columns Present in a table
Sql :: sql fill na with 0
Sql :: oracle trace session
Sql :: get first 3 letter of department name in sql
Sql :: update date of birth in sql
Sql :: postgres date difference seconds
Sql :: Database "mem:testdb" not found, either pre-create it or allow remote database creation (not recommended in secure environments) [90149-200] 90149/90149 (Help)
Sql :: return insert results in POSTGRESQL
Sql :: postgres count string length
Sql :: find logged in users mysql
Sql :: get monday of current week sql
Sql :: postgresql change value in column
Sql :: sql current year
Sql :: size of all tables in a schema oracle
Sql :: mysql to lowercase
Sql :: oracle sessions_per_user
Sql :: connecting to mysql database using python
Sql :: t-sql get duplicate rows
Sql :: view t-sql mail configuration
Sql :: mysql update table from another table
Sql :: postgres convert number to string
Sql :: check mysql username and password ubuntu
Sql :: sqlite show table definition
Sql :: mysql install with docker
Sql :: sql server sleep
Sql :: show constraints mysql