一条语句简单解决“每个Y的最新X”的经典sql语句

代码如下:/****** 创建表 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Table]’) and OBJECTPROPERTY(id, N’IsUserTable’) = 1) drop table [dbo].[Table] GO Create TABLE [dbo].[Table] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [Y] [nvarchar] (50) COLLATE Chin