Ifnull In Sql Server

[Solved] Ifnull In Sql Server | Php - Code Explorer | yomemimo.com
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

Answers related to ifnull in sql server

Code Explorer Popular Question For Php