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以上
转载于:https://www.cnblogs.com/ODOD/p/11532633.html
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以上
转载于:https://www.cnblogs.com/ODOD/p/11532633.html