表名是voyagemaster。如何选择不同的船只,并且一个船只也有很多航次,因此我要添加航次以便将航次选择为max(voyagedate)。根据船只选择max(voyagedate)和voyagenumber。怎么解决..
select distinct(Vessel), VoyageID, VoyageNumber, max(VoyageDate) as vdate, VIA,
ROTNo, CutOffDate, CutOffTime, ETA, ETD
from VoyageMaster
group by Vessel
预先感谢
试试这个 :
SELECT A.Vessel,V1.VoyageID,V1.VoyageNumber,A.VoyageDate
FROM VoyageMaster V1
JOIN ( SELECT Vessel,MAX(VoyageDate) VoyageDate
FROM VoyageMaster
GROUP BY Vessel ) A
ON A.Vessel = V1.Vessel
AND V1.VoyageDate = A.VoyageDate
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句