SELECT a.SER_NUM,a.PER_NUM,a.VORDER
FROM (SELECT ch.SER_NUM,ch.PER_NUM,ch.VORDER FROM CHENGY_HZ ch WHERE ch.VORDER=1) a
WHERE NOT EXISTS(
SELECT b.*
FROM (SELECT ch.SER_NUM,ch.PER_NUM,ch.VORDER FROM CHENGY_HZ ch WHERE ch.VORDER=1) b
WHERE b.SER_NUM = a.SER_NUM
AND b.PER_NUM>a.PER_NUM )
方法二:
SELECT MIN(m.ORDERNO),m.GROUPSNO FROM MEMBER m GROUP BY m.GROUPSNO