公式写在的oracle表中,请教sql,表中字段里有公式，怎么写出结果值

最新推荐文章于 2025-02-25 10:45:31 发布

神楽坂有木

最新推荐文章于 2025-02-25 10:45:31 发布

阅读量366

点赞数

文章标签：公式写在的oracle表中

该博客内容涉及SQL查询操作，展示了一段用于筛选特定日期（2015-10）数据的查询语句，数据包括不同用户的交易记录，如'张三'和'李四'等。查询结果按工号(date_gh)升序和item_id排序。

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

数据表(pay_data )：

with pay_data as (

select 'c1' date_item_id,'张三' date_xm,'157' date_gh,'2015-10-19' date_sj,'2015-10' data_yf,'b1' date_type,'100' date_val from dual union all

select 'c2' date_item_id,'张三' date_xm,'157' date_gh,'2015-10-19' date_sj,'2015-10' data_yf,'b1' date_type,'101' date_val from dual union all

select 'c3' date_item_id,'张三' date_xm,'157' date_gh,'2015-10-19' date_sj,'2015-10' data_yf,'b1' date_type,'102' date_val from dual union all

select 'c4' date_item_id,'张三' date_xm,'157' date_gh,'2015-09-10' date_sj,'2015-10' data_yf,'b1' date_type,'103' date_val from dual union all

select 'c5' date_item_id,'张三' date_xm,'157' date_gh,'2015-09-10' date_sj,'2015-10' data_yf,'b1' date_type,'104' date_val from dual union all

select 'c6' date_item_id,'张三' date_xm,'157' date_gh,'2015-09-10' date_sj,'2015-10' data_yf,'b1' date_type,'105' date_val from dual union all

select 'c7' date_item_id,'张三' date_xm,'157' date_gh,'2015-09-10' date_sj,'2015-10' data_yf,'b1' date_type,'106' date_val from dual union all

select 'c8' date_item_id,'张三' date_xm,'198' date_gh,'2015-10-19' date_sj,'2015-10' data_yf,'b1' date_type,'107' date_val from dual union all

select 'c10' date_item_id,'张三' date_xm,'198' date_gh,'2015-10-19' date_sj,'2015-10' data_yf,'b1' date_type,'108' date_val from dual union all

select 'c1' date_item_id,'李四' date_xm,'198' date_gh,'2015-10-19' date_sj,'2015-10' data_yf,'b1' date_type,'109' date_val from dual union all

select 'c2' date_item_id,'李四' date_xm,'198' date_gh,'2015-09-10' date_sj,'2015-10' data_yf,'b1' date_type,'110' date_val from dual union all

select 'c3' date_item_id,'李四' date_xm,'198' date_gh,'2015-09-10' date_sj,'2015-10' data_yf,'b1' date_type,'111' date_val from dual union all

select 'c5' date_item_id,'李四' date_xm,'198' date_gh,'2015-09-10' date_sj,'2015-10' data_yf,'b1' date_type,'112' date_val from dual union all

select 'c4' date_item_id,'李四' date_xm,'198' date_gh,'2015-09-10' date_sj,'2015-10' data_yf,'b1' date_type,'113' date_val from dual union all

select 'c8' date_item_id,'李四' date_xm,'212' date_gh,'2015-10-19' date_sj,'2015-10' data_yf,'b1' date_type,'114' date_val from dual union all

select 'c9' date_item_id,'李四' date_xm,'212' date_gh,'2015-10-19' date_sj,'2015-10' data_yf,'b1' date_type,'115' date_val from dual union all

select 'c10' date_item_id,'李四' date_xm,'212' date_gh,'2015-10-19' date_sj,'2015-10' data_yf,'b1' date_type,'116' date_val from dual union all

select 'c1' date_item_id,'五子' date_xm,'212' date_gh,'2015-10-10' date_sj,'2015-10' data_yf,'b1' date_type,'117' date_val from dual union all

select 'c6' date_item_id,'五子' date_xm,'212' date_gh,'2015-09-10' date_sj,'2015-10' data_yf,'b2' date_type,'118' date_val from dual union all

select 'c5' date_item_id,'五子' date_xm,'212' date_gh,'2015-09-10' date_sj,'2015-10' data_yf,'b3' date_type,'119' date_val from dual union all

select 'c4' date_item_id,'五子' date_xm,'212' date_gh,'2015-09-10' date_sj,'2015-10' data_yf,'b1' date_type,'120' date_val from dual

)

select * from pay_data where data_yf='2015-10' order by date_gh asc,date_item_id asc