I have 10 field that I want to calculate the total. some of the fields take null value. I tried the codes below but the result was empty.
select id, (c1+c2+c3+c4+c5+c6+c7+c8+c9+c10) as total from items order by id;
the result show was null. In dreamweaver the result was blank.
please kindly help me out.
By Franz
Hi, use the coalesce() function:
select id, coalesce(c1, 0) + coalesce(c2, 0) + coalesce(c3, 0) ...
In practice, if the value of cN is null it will output 0.
Docs:
Bye!
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.