数据表(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