sql 查询,把查出的数据作为临时表在进行查询

select count(*) total from (

select count(*) total  from sys_user a

 left join fsms_fee_splitting b on a.su_name=b.fs_parent_id  ----------------------left join联合查询

where       a.su_type in ('3') 

group by a.su_id       ---------------------------------------------------------------指定分组    

    ) as temp---------------------------------temp为临时表，count（）数据有几行