SQL Type subtype Statistics

SELECT * from TestTable;

Type subtype Value

A SA 1
Bsb1
Asberror
Bsaerror
Asb1
Bsb1
Csaerror
Csb1
Csc1
Csc1
Csaerror

Select sum (' value ') from testtable where value! = ' ERROR ' and type = ' B ';

SUM (' value ')

2

SELECT Type,subtype,sum (value) as Totnum from testtable WHERE value! = ' ERROR ' GROUP by Type,subtype;

Type subtype Totnum

A SA 1
Asb1
Bsb2
Csb1
Csc2
Csc2

SELECT Type,subtype,count (value) as Totcount from testtable WHERE value = ' ERROR ' GROUP by Type,subtype;

Type subtype Totcount

A SB 1
Bsa1
Csa2
Csa2

SELECT * FROM (case when value <> ' ERROR ' then value Else ' 0 ' end) as total, sum (case when Valu E = ' ERROR ' then 1 Else ' 0 ' end ' as Error line ' from TestTable Group by Type,subtype ' t ORDER by total desc

Type subtype total number of error rows

C SC 2 0
Bsb20
Asa10
Csb10
Asb11
Csa02
Bsa01

SQL Type subtype Statistics