Question : ifnull in sql
Answered by : sita-chandra-mallipamula
select id, ifnull(marks,0) from students;
#if marks=NULL, replaces value with 0
Source : | Last Update : Mon, 25 Dec 23
Question : ifnull in sql server
Answered by : shahid-ruxa6lrwg801
# Id ProductName UnitPrice UnitsInStock UnitsOnOrder
# 1 Jarlsberg 10.45 16 15
# 2 Mascarpone 32.56 23
SELECT ProductName, UnitPrice * (UnitsInStock + IFNULL(UnitsOnOrder, 0)) FROM Products;
Source : | Last Update : Sun, 30 Oct 22