SELECT DISTINCT
sw.fname AS `车间名称`,
COUNT(sc.workshop_id) AS `机柜数`
FROM
scada_cabinet AS sc,
scada_workshop AS sw
WHERE
sc.workshop_id = sw.fid
GROUP BY
sc.workshop_id
ORDER BY
sw.fid ASC
以饼图方式显示:
保存柱状图:
以柱状图方式显示:
保存:
SELECT DISTINCT
sw.fname AS `车间名称`,
COUNT(sc.workshop_id) AS `机柜数`
FROM
scada_cabinet AS sc,
scada_workshop AS sw
WHERE
sc.workshop_id = sw.fid
GROUP BY
sc.workshop_id
ORDER BY
sw.fid ASC
以饼图方式显示:
保存柱状图:
以柱状图方式显示:
保存: