DevExper

Development Experience

Thursday, July 31, 2014

MsSql Server sql IF Sum is null convert it to 0 (zero)

IF Sum is null convert it to 0 (zero)

by on in ,

Oracle you may use the query below to convert SUM of totalPrice to zero when SUM result is null by using COALESCE 


select  COALESCE(SUM(totalPrice),0) "Total"  from productPriceTable
By zaman:
Etiketler: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)