展开全部
|
1
mysql 的话就如下,也62616964757a686964616fe59b9ee7ad9431333332616463没啥简单的办法:select isnull(A)+isnull(B)+isnull(C)+isnull(D)
from 表
测试结果:
mysql> select * from tbTest;
+---+------+------+------+
| a | b | c | d |
+---+------+------+------+
| 1 | NULL | 2 | NULL |
| 3 | NULL | 5 | 7 |
+---+------+------+------+
2 rows in set (0.00 sec)
mysql> select isnull(A)+isnull(B)+isnull(C)+isnull(D)
-> from tbTest;
+-----------------------------------------+
| isnull(A)+isnull(B)+isnull(C)+isnull(D) |
+-----------------------------------------+
| 2 |
| 1 |
+-----------------------------------------+
2 rows in set (0.03 sec)