orcl 数据查询优先级
来源:互联网 发布:图片毛玻璃效果 软件 编辑:程序博客网 时间:2024/05/22 17:32
with a as (select '1' as id, '02' as trantype, '1000.00' as raiseamt, '1' as transtate from dual union
select '2' as id, '02' as tranType, '1000.00' as raiseAmt, '2' as tranState from dual union
select '3' as id, '02' as tranType, '1000.00' as raiseAmt, '1' as tranState from dual union
select '4' as id, '02' as tranType, '1000.00' as raiseAmt, '3' as tranState from dual union
select '5' as id, '02' as trantype, '1000.00' as raiseamt, '1' as transtate from dual
) select id, trantype, raiseamt, transtate
from a
order by decode(transtate, '1', '1', '3', '0', '2', '2');
阅读全文
0 0
- orcl 数据查询优先级
- orcl分页查询详解
- Orcl分页查询
- orcl数据字典
- orcl SQL简单查询语句
- orcl 查询锁表 解锁
- ORCL删除表里面重复数据
- orcl数据库备份数据的命令
- 浏览器查询参数与表单数据的优先级问题
- ORCL数据字典(10级学员 张家玮整理)
- orcl clob 数据插入报错处理_test
- 运算符优先级查询表
- ORCL 卸载
- ORCL SYS
- Orcl服务
- orcl中查询两个时间的差值(包括时分秒)
- 数据机构之优先级队列
- 关于nucleus中的优先级查询表
- 25. Reverse Nodes in k-Group(链表k-组反转)
- 如何防止HA集群的脑裂
- Android Lib层打印log之------bionic库打印log
- 关于string类中的一些小问题的总结
- (HihoCoder
- orcl 数据查询优先级
- single-number-ii
- 354. Russian Doll Envelopes
- flume之intercept
- 【Cumputer】《第一次机房收费系统》总结三 组合查询
- 使用Chisel来突破公司代理服务器的封锁
- SourceTree解决冲突
- Android界面调试的基本方法---bitmap显示出来
- 事件总线框架EventBus和Otto学习笔记