orcl 数据查询优先级

最新推荐文章于 2023-09-11 17:26:12 发布

原创最新推荐文章于 2023-09-11 17:26:12 发布 · 335 阅读

0 ·

CC 4.0 BY-SA版权

本文通过具体的 Oracle SQL 示例代码，展示了如何使用 UNION 和 DECODE 函数来生成带有不同状态的事务记录，并按特定规则进行排序。这对于理解 SQL 中的数据操作和函数应用非常有帮助。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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');