SQL问题：查询所有生产工单最后是由哪条生产线哪一天生产的并显示当天的产量

Question

Table: dailyprod
primary key: prod_date+ prod_line + prod_job

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

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

Answer 1

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 ;