SQL One statement statistic record total and each state number _mssql

Method One,

Copy Code code as follows:

SELECT sum (the correct number) +sum (Error number) as total record number, sum (correct number), sum (Number of errors)
From (
SELECT count (1) correct number, 0 error number
From TB
WHERE Status=1
UNION All
SELECT 0 Correct number, COUNT (1) Error
From TB
WHERE status=0) A

Method Two,

Copy Code code as follows:

Select COUNT (1) Total records, sum (case when Status=1 then 1 else 0-end) correct number, sum (case when status=0 then 1 else 0-end) error number from T