select findex,max(运费) as 最大运费 from table1 group by findex
SELECT ship_no, ship_fee, findex FROM tab WHERE NOT EXISTS (SELECT 1 FROM tab t WHERE t.ship_no = ship_no AND t.findex < findex);
t.findex < findex 小于号改成大于号
楼主要的是这个吧。 SELECT a.*, b.max_findex FROM table1 JOIN ( SELECT 发运单编号,MAX(findex) max_findex FROM table1 GROUP BY 发运单编号 ) b ON a.发运单编号 = b.发运单编号 ORDER BY a.发运单编号, a.findex
WHERE NOT EXISTS (SELECT 1 FROM tab t WHERE t.ship_no = ship_no AND t.findex < findex);
SELECT a.*, b.max_findex
FROM table1
JOIN ( SELECT 发运单编号,MAX(findex) max_findex
FROM table1
GROUP BY 发运单编号
) b
ON a.发运单编号 = b.发运单编号
ORDER BY a.发运单编号, a.findex