-- COUNT ALL
select count(*) from result;
-- COUNT SAME
select count(*) from result where not (dif_date != 0  or
                              dif_km != 0 or
                              dif_price != 0 or
                              dif_tech != 0 or
                              dif_desc != 0 or
                              dif_eqpm != 0 or
                              dif_sllr != 0 or
                              dif_extr != 0 );
-- COUNT DIFS ADD RUN
select count(*) from result where (dif_date != 0  or
                              dif_km != 0 or
                              dif_price != 0 or
                              dif_tech != 0 or
                              dif_desc != 0 or
                              dif_eqpm != 0 or
                              dif_sllr != 0 or
                              dif_extr != 0 ) 
                              and systemvalidsince >= (select min(systemvalidsince)+1 from result)
;
-- COUNT DIFS
select count(*) from result where (dif_date != 0  or
                              dif_km != 0 or
                              dif_price != 0 or
                              dif_tech != 0 or
                              dif_desc != 0 or
                              dif_eqpm != 0 or
                              dif_sllr != 0 or
                              dif_extr != 0 ) 
                              --and systemvalidsince not in (to_date('30.12.2014','DD.MM.YYYY'),to_date('31.01.2015','DD.MM.YYYY'))
;                              
-- COUNT NULLS
select * from result where (dif_date is null  or
                              dif_km is null or
                              dif_price is null or
                              dif_tech is null or
                              dif_desc is null or
                              dif_eqpm is null or
                              dif_sllr is null or
                              dif_extr is null ) 