Less is More£¨ÉÙ¼´ÊǶࣩ

ÕªÒª£º count(if(a.STS = #{sts}, a.sts, null)) as scssCnt, sum(if(a.sts = #{sts}, a.amt, 0)) as scssAMt View Code ÔĶÁÈ«ÎÄ

ÕªÒª£º insert into table_name ( id, name ) ( select stu_id, stu_name from stu_table where stu_id = #{stuId} ) ÔĶÁÈ«ÎÄ