34,594
社区成员
发帖
与我相关
我的任务
分享
select * from SoftwareList where id in (select min(ID) from SoftwareList group by StationName ) and ProductionPhase ='SMT' and Platform='MTK' order by Version desc
SELECT * FROM (SELECT * ,ROW_NUMBER()OVER(PARTITION BY StationName ORDER BY [Version] DESC) AS RN,MIN(ID)OVER(PARTITION BY StationName) AS MinID FROM SoftwareList ) AS a WHERE RN=1 ORDER BY a.MinID
SELECT Platform,ProductionPhase,StationName,SoftwareName,Version,Size FROM (SELECT Platform,ProductionPhase,StationName,SoftwareName,Version,Size ,ROW_NUMBER()OVER(PARTITION BY StationName ORDER BY [Version] DESC) AS RN FROM SoftwareList ) AS a WHERE RN=1 and ProductionPhase ='SMT' and Platform='MTK'
SELECT * FROM (SELECT * ,ROW_NUMBER()OVER(PARTITION BY StationName ORDER BY [Version] DESC) AS RN FROM SoftwareList ) AS a WHERE RN=1