mysql查询去重

SELECT count(DISTINCT type) as count ,dms_warehouse_id as whId from bms_warehouse_supplies where dms_warehouse_id in (1,2,3) GROUP BY dms_warehouse_id
mysql版本需要4.0以上

posted @ 2019-09-17 11:33  无敌哈士奇  阅读(668)  评论(0)    收藏  举报