34,591
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE #TEMP(ID VARCHAR(2),ID2 VARCHAR(2))
INSERT INTO #TEMP
SELECT 'A1','B1'
UNION ALL
SELECT 'A1','B1'
UNION ALL
SELECT 'A1','B2'
UNION ALL
SELECT 'A2','B2'
UNION ALL
SELECT 'A2','B3'
UNION ALL
SELECT 'A3','B1'
SELECT DISTINCT * FROM #TEMP T0 WHERE NOT EXISTS(SELECT 1 FROM #TEMP WHERE T0.ID=ID AND T0.ID2>ID2)
/*
ID ID2
A1 B1
A2 B2
A3 B1
*/
select Columns1,min(Columns2) from tb group by Columns1
select * from tb t where columns2=(select min(columns2) from tb where columns=t.columns)
select Columns1 ,min(Columns2) from tb group by Columns1