--在一个表table1中有三列A,B,C,求查找出A,B,C中都等于“abc”的数据，然后按A="abc"的数据排前面，
--b="abc"排中间,c="abc"排最后的排序，用一条查询语句怎么做？
use a
go
create table table1
( a varchar(5),b varchar(5),c varchar(5) )
insert into table1(a,b,c)
select 'a','aaa','abc'union
select 'aa','bb','cc'union
select 'abc','ss','aa'union
select 'ac','abc','a'union
select 'aaa','bb','ccc'union
select 'q','abc','abc'union
select 'aq','a','q'union
select 'asd','abc','ab'
--代码
select * from table1
where A ='abc'
or B ='abc'
or c= 'abc'
order by case when a='abc' then 0
when B='abc' then 1
when C='abc' then 2
else 3 end