SELECT DISTINCT KSTerm FROM [dbo].[RMScoreInfoCollections] WHERE LEFT(KSTerm,4) > (Year(GETDATE()) - 3) 转载于:https://www.cnblogs.com/Anthony518/p/10910170.html