sql


1.
$whe_s=array();
$whe_s['is_delete']=0;
$student_list = Db::name('learn_wei')->
field( 'name, academe, zbname, Count(*) cou')->
where($whe_s)->
where($condition2)->
group('name,academe,zbname')->
select();
2.
SELECT name, academe, zbname, Count(*) cou FROM tp_learn_wei GROUP BY name, academe,zbname;where is_learn =1 and is_delete = 0

posted @ 2022-09-15 16:55  谢凌  阅读(14)  评论(0编辑  收藏  举报