SELECT T1.FRAMENO, T1.UNDERTAKER10,T1.STATUSCODEDATE10, MAX(T1.STATUSCODEDATE10) OVER(PARTITION BY T1.FRAMENO) FROM RT_REPAIR T1 WHERE T1.STATUSCODEDATE10 IS NOT NULL ORDER BY T1.FRAMENO,T1.STATUSCODEDATE10
原文：http://www.cnblogs.com/ShaYeBlog/p/4238524.html