Table: dailyprod
primary key: prod_date+ prod_line + prod_job

详见数据表：
(https://img-ask.csdn.net/upload/201809/15/1536985570_891199.jpg)

请用sql查询所有生产工单最后是由哪条生产线哪一天生产的并显示当天的产量

SELECT d.* FROM dailyprod d INNER JOIN
(SELECT prod_job,max(pro_date) as pro_date FROM dailyprod GROUP BY prod_job) as p on p.pro_date=d.pro_date AND p.prod_job = d.prod_job ;

各位大神，我再问一个问题：

请用SQL查询 12/Oct/2015 当天产量最高的生产线并提示其产量

select prod_line ,sum(prod_qty) from dailyprod where prod_date='12/Oct/2015' group by prod_line having count(prod_qty) > 1;是否正确？