leedonet

SELECT * FROM (WITH SUB_DATA_CUST AS ( SELECT /*+USE_HASH(A C)*/ 'C' AS COMP_CD, A.STD_YM, A.BRND_CD, A.LARG_CTG_CD, A.CUST_CD, SUM (A.NET_SALE_AMT) AS SALE_AMT, SUM (A.NET_SALE_QTY) AS SALE_QTY, SUM (A.SALE_PROF_AMT) AS PROF_AMT, SUM...

SELECT B.COMP_CD, B.CUST_CD, B.BRND_CD, B.LARG_CTG_CD, SUM(B.SALE_AMT) AS SALE_AMT FROM ( SELECT TO_CHAR(ADD_MONTHS (TO_DATE (TO_CHAR (ADD_MONTHS (SYSDATE, -15),'YYYYMM'),'YYYYMM'), LEVEL - 1),'YYYYMM') AS STD_YM, RANK() OVER ( ORDER BY TO_CHAR(ADD_MONTHS(TO_DATE(TO_CHAR(ADD_MONTHS(SYSDATE, -15), 'YYYYMM'),...

Thanks for the explanation above.

Also, please check the query below. SELECT /*+ FULL(S1) */ MDT_YR AS MDT_YR ,S1.UTK_NO AS UTK_NO ,S1.HTP AS HTP ,NVL(S2.RNT_ASAMT,0) AS RNT_ASAMT ,NVL(RNT_ASAMT_MDT_RT,0) AS RNT_ASAMT_MDT_RT ,NVL(S3.RNT_ASAMT,0) AS SML_ARE_RNT_ASAMT ,'N' AS...

Although I will appreciate when you won't mix completely unrelated questions into one issue. => Okay. thank you 1. has the question about PARTITION BY been answered, can we close...

Can I ask you another question? Even if ParserException occurs using JSqlParser Can I get SelectItems? Is there a way to extract only column information?