sql查询结果排序问题 - MS-SQL Server / 基础类

sql 查询结果排序问题
先查出来的放在表前面

 比如：搜索关键字 ：'北京 高考'
1。查询结果 同时 匹配 “北京”“高考”
select * from News where Title like '%北京%' and ''Title like '%高考%'
2。匹配一个关键字 
select * from News where Title like '%北京%' or ''Title like '%高考%'

问题：我要把同事匹配 北京 高考 的放在最前面，

---

SQL code:
select (case when Title like '%北京%' then 1
when Title like '%高考%' then 2
when Title like '%北京%' and ''Title like '%高考%' then 0
else 3 end) o,*
from News where Title like '%北京%' and ''Title like '%高考%'
order by o

---

试试看
SQL code:
select * from News
where (Title like '%北京%' and Title like '%高考%')
or Title like '%北京%' or Title like '%高考%'
order by case when (Title like '%北京%' and Title like '%高考%') then 0 else 1 end

---

SQL code:
select
(case when Title like '%北京%' then 1
when Title like '%高考%' then 2
when Title like '%北京%' and Title like '%高考%' then 0
else 3 end) o,*
from News where Title like '%北京%' and ''Title like '%高考%'
order by o