老山,這是實現語句,在 MS SQL 7.0調試通過.表名為Tbl_Temp SELECT bb.DECL_NO, bb.FEE_NO FROM Tbl_Temp bb INNER JOIN (SELECT DECL_NO, MAX(FEE_NO) AS Expr1 FROM Tbl_Temp GROUP BY DECL_NO) aa ON bb.DECL_NO = aa.DECL_NO AND bb.FEE_NO = aa.Expr1 ORDER BY bb.DECL_NO, bb.FEE_NO
我总觉的题说得不清楚! 我认为:(相关子查询的典型例子)SELECT * FROM [Table] WHERE [Table].[FEE_NO] = (SELECT Max(FEE_NO) FROM [Table] AS [T1] WHERE [T1].[DECL_NO] = [Table].[DECL_NO] GROUP BY [T1].[DECL_NO])
210100100000579 3
210100100000579 3
210100100000579 3
210100100000579 3
210100100000579 3这些数据都选出来...当然.还有其它的数据在这个表里.
我的判断条件只有fee_no最大这一个..
而用上面的方法只能选出一条记录.而我得选出5条...
(SELECT DECL_NO, MAX(FEE_NO) AS Expr1 FROM Tbl_Temp
GROUP BY DECL_NO) aa ON bb.DECL_NO = aa.DECL_NO AND bb.FEE_NO = aa.Expr1
ORDER BY bb.DECL_NO, bb.FEE_NO
我认为:(相关子查询的典型例子)SELECT *
FROM [Table]
WHERE [Table].[FEE_NO] = (SELECT Max(FEE_NO)
FROM [Table] AS [T1]
WHERE [T1].[DECL_NO] = [Table].[DECL_NO]
GROUP BY [T1].[DECL_NO])