Select to_char(tran_date,'yyyy.mm'), SUM( DECODE ( bank_code,'001', tran_val,0 )) 城西區(qū), SUM( DECODE ( bank_code,'002', tran_val,0 )) 城南區(qū), SUM( DECODE ( bank_code,'003', tran_val,0 )) 城東區(qū) FROM pay_lst GROUP BY to_char(tran_date,'yyyy.mm'); 建立視圖后,可...
www.dbjr.com.cn/article/364...htm 2025-6-1