thinkphp 查询数据库数据根据两个字段group,且统计条数用法
$result=M("sale_lead")
->field("lead_source,created_by,count(sale_lead_id ) as count_num")
->group("lead_source,created_by")
->where($where)
->select();
结果:
array(14) {
[0] => array(3) {
["lead_source"] => string(1) "1"
["created_by"] => string(2) "42"
["count_num"] => string(1) "1"
}
[1] => array(3) {
["lead_source"] => string(1) "3"
["created_by"] => string(2) "43"
["count_num"] => string(1) "1"
}
[2] => array(3) {
["lead_source"] => string(1) "4"
["created_by"] => string(2) "29"
["count_num"] => string(1) "2"
}
[3] => array(3) {
["lead_source"] => string(1) "5"
["created_by"] => string(2) "29"
["count_num"] => string(1) "1"
}
[4] => array(3) {
["lead_source"] => string(1) "5"
["created_by"] => string(2) "42"
["count_num"] => string(1) "1"
}
[5] => array(3) {
["lead_source"] => string(1) "6"
["created_by"] => string(2) "29"
["count_num"] => string(1) "2"
}
[6] => array(3) {
["lead_source"] => string(1) "7"
["created_by"] => string(2) "42"
["count_num"] => string(1) "1"
}
[7] => array(3) {
["lead_source"] => string(1) "7"
["created_by"] => string(2) "43"
["count_num"] => string(1) "2"
}
[8] => array(3) {
["lead_source"] => string(1) "8"
["created_by"] => string(2) "42"
["count_num"] => string(1) "5"
}
[9] => array(3) {
["lead_source"] => string(1) "8"
["created_by"] => string(2) "43"
["count_num"] => string(1) "2"
}
[10] => array(3) {
["lead_source"] => string(2) "13"
["created_by"] => string(2) "43"
["count_num"] => string(1) "1"
}
[11] => array(3) {
["lead_source"] => string(2) "43"
["created_by"] => string(2) "43"
["count_num"] => string(1) "2"
}
[12] => array(3) {
["lead_source"] => string(2) "44"
["created_by"] => string(2) "43"
["count_num"] => string(1) "1"
}
[13] => array(3) {
["lead_source"] => string(2) "45"
["created_by"] => string(2) "43"
["count_num"] => string(1) "1"
}
}声明:该文观点仅代表作者本人,入门客AI创业平台信息发布平台仅提供信息存储空间服务,如有疑问请联系rumenke@qq.com。
