select语句能按where条件排序么?

[forever_ylx]

select a from 表 where (a='xx' or a='yy' or a='zz')

结果：
a
----
xx
yy
zz


select a from 表 where (a='xx' or a='zz' or a='yy')

结果：
a
----
xx
zz
yy

select语句能按where条件排序么?该怎么写呢？

[让你望见影子的墙]

select a from 表 where (a='xx' or a='zz' or a='yy')
order by charindex(a,'xx,zz,yy')

[SQL77]

select a from 表 where (a='xx' or a='yy' or a='zz') 
ORDER BY A 

?

[SQL77]

select a from 表 where (a='xx' or a='yy' or a='zz') 
ORDER BY CHARINDEX(A,'XX,ZZ,YY')

[pt1314917]

select a from 表 where (a='xx' or a='zz' or a='yy') 
order by case a when 'xx' then 1 when 'zz' then 2 else 3 end

[dawugui]

select a from 表 where (a='xx' or a='yy' or a='zz') 
 order by a

[feixianxxx]

declare @a varchar(10),@b varchar(10),@c varchar(10),@s varchar(8000)
set @a='xx'
set @b='zz'
set @c='yy'
set @s='select a from 表 where ( a='''+@a+''' or a='''+@b+''' or a='''+@c+''')'
        +' order by charindex(a,''@a+@b+@c'')'
exec (@s)

通过 @a @b @c 控制

[icelovey]

[Quote=引用 6 楼 feixianxxx 的回复:]
SQL codedeclare@avarchar(10),@bvarchar(10),@cvarchar(10),@svarchar(8000)set@a='xx'set@b='zz'set@c='yy'set@s='select a from 表 where ( a='''+@a+''' or a='''+@b+''' or a='''+@c+''')'+' order by charindex(a,''@a+@b+@c'')'exec (@s)
通过 @a @b @c 控制
[/Quote]
UP

[zmx0506]

大家太有才了，能写出这么多花样来

[--小F--]

select
 a 
from 
 tb 
 where
 a='xx' or a='zz' or a='yy' 
order by 
 charindex(a,'xx,zz,yy')

[huangqing_80]

declare @mytb table(col1 char(3),col2 char(2),col3 decimal(3,0))
insert @mytb select 'xx','ac',3 union 
			select 'yy','ad',5 union
			select 'zz','ab',6 union
			select 'aa','b4',7 union
			select 'bb','a4',8 
select * from @mytb where (col2='ab' or col2='ac' or col2='ad') order by col2

[yanglinqiang]

select a from 表 where a="xx"
union all select a from 表 where a="zz"
union all select a from 表 where a="yy"

[yanglinqiang]

[Quote=引用 9 楼 fredrickhu 的回复:]
SQL codeselect
afrom
tbwhere
a='xx'or a='zz'or a='yy'orderbycharindex(a,'xx,zz,yy')
[/Quote]
这个好……