SELECT
t1.pk
FROM
process40 t1
RIGHT JOIN (
SELECT
t01.productPk,
max(t01.工序行号) ha
FROM
process40 t01
WHERE
t01.pk IS NOT NULL
GROUP BY
t01.productPk
) b ON b.productPk = t1.productPk
AND b.ha = t1.工序行号
ORDER BY
t1.`工序行号` asc
利用 相同产品的行号不会重复 group by 什么字段,select 什么字段
贰 这个比较通用
SELECT
e.deptno,
ename,
sal
FROM
emp e,
( SELECT deptno, max( sal ) maxsal FROM emp GROUP BY deptno ) t
WHERE
e.deptno = t.deptno
AND e.sal = t.maxsal;