如下SQL问题 3F币

回答：CASE WHEN 科目编号  IN ('6603040000',...,'6603189999') AND 成本编号 ='1000' THEN '区间一'科目编号  IN ('6603200000',...,'6603999999') AND 成本编号 ='1000' THEN '区间二' END  区间分类

2022年06月23日回复

数据字典只能影响一行 3F币

回答：[图片]

2022年06月23日回复

sql求助 3F币

回答：SELECT RQ, WM_CONCAT ( ID ) FROM ( SELECT ROW_NUMBER ( ) OVER ( PARTITION BY TRUNC( DATE, 'DD' ) ORDER BY SUM( QTY ) DESC ) XH, TRUNC( DATE, 'DD' ) RQ, ID, SUM( QTY ) SHUL  FROM MX  WHERE TRUNC( SYSDATE, 'DD' )-TRUNC( DATE, 'DD' ) <=30 GROUP BY ID, TRUNC( DATE, 'DD' )  ORDER BY TRUNC( DATE, 'DD' ), SUM( QTY ) DESC  ) WHERE XH <= 3 GROUP BY RQ

2022年06月22日回复

3

3

4

10