更新时间:2023-01-07 21:53:56
尝试使用group by
SELECT type,count(*) as cnt
FROM TCONTENTNODE
WHERE parentid ='02b3abc2-4983-485a-ab09-1a8cb328b9b5';
group by type
两个变量:
SELECT
COUNT(case TCONTENTNODE.type when '2' then 1 end) as _countA,
COUNT(case TCONTENTNODE.type when '3' then 1 end) as _countB
FROM TCONTENTNODE
WHERE TCONTENTNODE.parentid ='02b3abc2-4983-485a-ab09-1a8cb328b9b5';