SELECT * FROM Temp A WHERE BF=(SELECT MAX(BF) FROM Temp WHERE AF=A.AF) ORDER BY AF
SQL 按字段取最大值
最新推荐文章于 2024-08-16 15:19:25 发布
SELECT * FROM Temp A WHERE BF=(SELECT MAX(BF) FROM Temp WHERE AF=A.AF) ORDER BY AF