Add 2 query where other query is NULL

Question

I want to add to query but the other query sometimes the value is NULL

SELECT (a.column1+b.column2)/2 from (SELECT COUNT(column1) from table 1) a,
                                    (SELECT COUNT(column2) from table 2) b

The results of these query is like

(26248+NULL)/2 which gives NULL as a result

What result I want supposed to be 13124.

Is there anyway I can make this happen?

Gordon Linoff · Accepted Answer · 2014-05-20 18:26:23Z

2

You can use coalesce

 SELECT  (coalesce(a.column1,0)+ coalesce(b.column2,0))/2

COALESCE method return the first non-null parameter . so if b.column2 is null then it will return 0 .

edited May 20, 2014 at 18:26

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

answered May 20, 2014 at 18:22

echo_Me

37.2k5 gold badges62 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Add 2 query where other query is NULL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related