Oracle to migrate to MySQL, including the period of the grammar of the SQL statement needs to be converted to MySQL, racking their brains for a few days, write not to come out, please teach a great god!
Oracle - SQL is as follows:
The select SEQUENCE_JPA_ID NEXTVAL,
X.S ELLER_CODE,
7.0.x.x 1,
7.0.x.x 2,
7.0.x.x 3,
7.0.x.x 4,
7.0.x.x 5,
7.0.x.x 6,
'choseCooperationLenthPercent'

0,
1
The from (SELECT Margaret spellings ELLER_CODE,
PERCENTILE_CONT (0.05) WITHIN GROUP (ORDER BY M.I NDICATOR_VALUE) AS x1,
PERCENTILE_CONT (0.25) WITHIN GROUP (ORDER BY M.I NDICATOR_VALUE) AS x2,
PERCENTILE_CONT (0.5) WITHIN GROUP (ORDER BY M.I NDICATOR_VALUE) AS the x3,
PERCENTILE_CONT (0.75) WITHIN GROUP (ORDER BY M.I NDICATOR_VALUE) AS x4,
PERCENTILE_CONT (0.9) WITHIN GROUP (ORDER BY M.I NDICATOR_VALUE) AS the x5,
PERCENTILE_CONT (0.95) WITHIN GROUP (ORDER BY M.I NDICATOR_VALUE) AS x6
The FROM (SELECT T.S UPPLIER_CODE SELLER_CODE,
Tc USTOMER_CODE BUYER_CODE,
Max (tc) USTOMER_NAME BUYER_NAME,
Max (T.S UPPLIER_NAME) SELLER_NAME,
Months_between (sysdate, min (t.o rder_date) INDICATOR_VALUE
The FROM T_DT_SALE_INFO T
GROUP BY T.S UPPLIER_CODE, tc USTOMER_CODE) M
GROUP BY Margaret spellings ELLER_CODE) x;

CodePudding user response:

Urgent urgent!!! A great god for help all of you!