正如标题所说,如何 Select 每个assets资源 代码分组的最大序列号的行.
我try 了IN
子句运算符,但它不需要两列.
AssetCode SeqNo
---------------------------
AWET-2015-00001 1
AWET-2015-00001 2
AWET-2015-00001 3
AWET-2015-00001 4
AWET-2015-00002 1
AWET-2015-00002 2
AWET-2015-00002 3
代码:
SELECT *
FROM E_FixedAssetLedger
WHERE Fal_AssetCode, Fal_SeqNo IN (SELECT Fal_AssetCode, MAX(Fal_SeqNo)
FROM E_FixedAssetLedger
GROUP BY Fal_AssetCode)