SQL 多条件查询多结果

            var query = 'SELECT COUNT(*) as count_all , ' +
            		'SUM(Case when checkResult = 1 then 1 else 0 end ) as count_no, ' +
            		'SUM(Case when checkResult = 2 then 1 else 0 end ) as count_even, ' +
            		'SUM(Case when checkResult = 3 then 1 else 0 end ) as count_earn, ' +
            		'SUM(Case when checkResult = 4 then 1 else 0 end ) as count_lose, ' +
            		'checkTypeView as checkTypeView, '+
            		'checkNumber as checkNumber, '+
            		'FROM CheckList' +
            		' group by cellType'; 

这样查询结果将返回一个object对象，包含总数count_all，checkResult各不同的总数count_no，count_even，count_earn，count_lose，已经'checkTypeView 、'checkNumber 对象