-- 创建测试数据临时表
create table #t (name varchar(50));

-- 插入测试数据
insert into #t 
select 'A'
union all select 'B'
union all select 'C'
union all select 'A,B'
union all select 'A,B,C'
union all select 'A,B,C,E'
union all select 'A,B,C,F'
union all select 'A,B,E,F'
union all select 'A,B,F'
union all select 'A,B,F,N'
union all select 'A,B,F,Y'
union all select 'A,C'
union all select 'A,C,E'
union all select 'A,C,F'
union all select 'A,E'
union all select 'A,E,F'
union all select 'A,F'
union all select 'A,F,G'
union all select 'A,N'
union all select 'B,C'
union all select 'B,C,E'
union all select 'B,E'
union all select 'B,F'
union all select 'B,G'
union all select 'B,N'
union all select 'B,P'
union all select 'C,E'
union all select 'C,F'
union all select 'C,N'
union all select 'E,G'
union all select 'E,G,N'
union all select 'F,G'
union all select 'F,N'
union all select 'N,P,Q'
union all select 'N,Q';

-- 查询数据，按ascii码排序
--(注意这里是假设每个name里的字母都是按从小到大的顺序排好序的)
select * from #t order by REVERSE(name);