Question

sql 按or先后顺序排序

where Name like 'a%' or Name like '%a%' or cdsoDescribing like '%a%'怎样让它按or先后顺序排列比如：name :xabxnaaxb出来效果:axbxabxna

Answer 1

如袭芦铅果是有表里面有很多行的话，一个order by name是出不来拍好的，用临时表吧，oracle的话，就像这样;create table aaa_tmp asselect * from xx where name like 'a%'; insert into aaa_tmpselect * from xx where name like '%a%'; insert into aaa_tmpselect *from xx where name like '%a'; select * from aaa_tmp 这样得到的就是你要的结果了如果是sql server，把第一句哗绝改成select * into aaa_tmp from xx where name like 'a%';其他不变就行了

Answer 2

where( Name like 'a%'则稿纤 or Name like '%a%'敬陪 or cdsoDescribing like '孙仿%a%') order by Name

Answer 3

在后面加一句 order by name desc 就OK 了