CCyyll_168的博客

--上一月select to_char(trunc(sysdate,'MM')-1,'yyyy-MM-dd') from dual;--建立函数上周的开始时间create or replace function fun_acc_getlastweekstart(systemdate in date)  return varchar2 is  result_str varchar2(...

列转行有两种表示：第一种是分别把每个级别的的价格合成总数：select * from talbe pivot (sum( N_PRICE) for vc_level in ('初级' as primary,'中一级' AS middleLevel,'中二级' AS secondary,'中三级' AS secondaryThree,'高一级' AS highLevel, '高...