作者：刘浩不来丷上海594865126 | 来源：互联网 | 2024-09-28 12:40
摘自：https:www.cnblogs.comnick-huangp4076273.htmlselect*from(select'Nick'asitemfromd
摘自：
https://www.cnblogs.com/nick-huang/p/4076273.html
select * from (
select ‘Nick‘ as item from dual
union all
select ‘Viki‘ as item from dual
union all
select ‘Glen‘ as item from dual
union all
select ‘Robin‘ as item from dual
union all
select ‘Total‘ as item from dual
) pre_tab
order by decode(item, ‘Viki‘, 1, ‘Glen‘, 2, ‘Robin‘, 3, ‘Nick‘, 4, ‘Total‘, 99);
另外，在Report开发中，常需要将Total放最后，其它项则按其它排序方式（一般按正常的升序），可看作同一列有两种排序方式，那么可以这样：
select * from (
select ‘Nick‘ as item from dual
union all
select ‘Viki‘ as item from dual
union all
select ‘Glen‘ as item from dual
union all
select ‘Robin‘ as item from dual
union all
select ‘Total‘ as item from dual
) pre_tab
order by decode(item, ‘Total‘, 2, 1), item;
![Python3爬虫入门：pyspider的基本使用[python爬虫入门]](https://img1.php1.cn/3cdc5/324f/339/9d0ec9721f26646a.jpeg)
京公网安备 11010802041100号