DECLARE @TB TABLE(code VARCHAR(2), name NVARCHAR(4)) INSERT @TB SELECT '01', N'张三' UNION ALL SELECT '02', N'李四' UNION ALL SELECT '03', N'王五' UNION ALL SELECT '06', N'张三'SELECT name,min(code) as code FROM @TB GROUP BY name --OR SELECT name,MAX(code) as code FROM @TB GROUP BY name
INSERT @TB
SELECT '01', N'张三' UNION ALL
SELECT '02', N'李四' UNION ALL
SELECT '03', N'王五' UNION ALL
SELECT '06', N'张三'SELECT name,min(code) as code FROM @TB GROUP BY name
--OR
SELECT name,MAX(code) as code FROM @TB GROUP BY name