SELECT 职工号,供应商号,订购单号,订购日期,总金额 FROM 订购单 WHERE 总金额 IN (SELECT MAX(总金额) FROM 订购单 GROUP BY 职工号)
SELECT *,MAX(总金额) 总金额 FROM 订购单 GROUP BY 职工号