查询语言.groupBy
用法如下
Db::table('test', 'tid as id,tname as value')->
groupBy('id')->
groupBy('name')->
getAll();
# SELECT `test`.`tid` AS `id`,`test`.`tname` AS `value` FROM `test` GROUP BY `post`.`id`
getAll();
# SELECT `test`.`tid` AS `id`,`test`.`tname` AS `value` FROM `test` GROUP BY SUM(`test`.`num`)
Db::table('test', 'tid as id,tname as value')->
groupBy('{SUM([num])}')->
getAll();
groupBy("title,id,{concat('1234',[id],'ttt')}")->
getAll();
# SELECT `test`.`tid` AS `id`,`test`.`tname` AS `value` FROM `test` GROUP BY `test`.`title`,`test`.`id`,`test`.`ttt`,`test`.`value`
Db::table('test', 'tid as id,tname as value')->
groupBy(['title,id,ttt', 'value'])->
getAll();