declare @source table (id int not null identity primary key, name nvarchar(3)); insert into @source values ( 'C1' ) , ( 'B1' ) , ( 'X1' ) , ( 'A1' ) , ( 'B1' ) , ( 'C1' ) , ( 'B1' ) , ( 'A1' ) , ( 'X1' ) , ( 'C1' ) , ( 'D1' ) ; with grouped as ( select min(id) as minId, name from @source group by name ) select name from grouped order by minId;
Output
C1 B1 X1 A1 D1
0 comments:
Post a Comment