表table1 中字段id,url(地址),title(标题),body(内容),查询表table1中url(地址)或title(标题)或body(内容)含“baidu”的记录,要求:url(地址)含“baidu”的排在前面,title(标题)含“baidu”的排在其后,body含“baidu”的排在最后!
我的答案:
select a.* ,
case when url like '%baidu%' then 1
case when title like '%baidu%' then 2
case when body like '%baidu%' then 3
else 4 end new
from table1
where url like '%baidu%'
or title like '%baidu%'
or body like '%baidu%'
order by new
我的答案:
select a.* ,
case when url like '%baidu%' then 1
case when title like '%baidu%' then 2
case when body like '%baidu%' then 3
else 4 end new
from table1
where url like '%baidu%'
or title like '%baidu%'
or body like '%baidu%'
order by new
解决方案 »
- 请问如何能快速删除一个大表的某列
- 为什么redo log文件会丢失呢
- 急需oracle oajinit.exe文件
- ORACLE中给定一个日期,判断这个日期是否是工作日。
- oracle的oem问题
- Can't connect to X11 window server using '127.0.0.1:0.0' as the value of the DISPLAY variable.
- 10G emctl 起动失败
- 很简单的更新表时调用触发器错误,请帮忙看一下我的代码。
- 为什么一个表空间只能有一个LONG型数据列?
- 怎样用ADO向oracle写数据!!谢谢
- oracle 批量修改问题
- sql语句如何获取表的父节点?
然后合成一个排序
select 'baidu' url ,'dd' title,'baiduxx' body
from dual
union
select 'baidu' url ,'baidu' title,'baiduxx' body
from dual
union
select 'xx' url ,'baidu' title,'xx' body
from dual
union
select 'baidu' url ,'xx' title,'xx' body
from dual
union
select 'xx' url ,'xx' title,'baidu' body
from dual
union
select 'baidu' url ,'baidu' title,'baidu' body
from dual
select a.* ,
case when url like '%baidu%' then 1
when title like '%baidu%' then 2
when body like '%baidu%' then 3
else 4 end new
from ta_1 a
where url like '%baidu%'
or title like '%baidu%'
or body like '%baidu%'
order by new很好啊 这样