有没有统计以下的样式的oracle 语句
ID      A         B           C  
1       01A       01B         01C
2       01A       01B         01C
3       01A                   00C
4       00A                   001
5       001                   0002
6                 000         000
7                 002         050
8       00022     2222        
9       2222      456         
10                5589        5789
目的统计A B C 三列的总记录数 统计方法如下
A列总记录数 select count(1) from t where A is not null;
B列总记录数 select count(1) from t where B is not null;
C列总记录数 select count(1) from t where C is not null;我想问一种有没有把这三个语句简写的形式一下统计出 A  B  C 三列的总数,高手赐教

解决方案 »

  1.   


    select sum(decode(a,null,0,1)),sum(decode(b,null,0,1)),sum(decode(C,null,0,1)) from t;
      

  2.   

    ID      A        B          C  
    1      01A      01B        01C 
    2      01A      01B        01C 
    3      01A                 00C 
    4      00A                 001 
    5      001                 0002 
    6               000        000 
    7               002        050 
    8      000      222        
    9      2222     456        
    10              558        5789 
    这个样的