Oracle遷移到MySQL，其中有段SQL陳述句需要轉換成MySQL的語法，絞盡腦汁幾天了，寫不出來，求大神指教！
Oracle-SQL如下：
select SEQUENCE_JPA_ID.NEXTVAL,
x.SELLER_CODE,
x.x1,
x.x2,
x.x3,
x.x4,
x.x5,
x.x6,
'choseCooperationLenthPercent',
0,
1
from (SELECT M.SELLER_CODE,
PERCENTILE_CONT(0.05) WITHIN GROUP(ORDER BY M.INDICATOR_VALUE) AS x1,
PERCENTILE_CONT(0.25) WITHIN GROUP(ORDER BY M.INDICATOR_VALUE) AS x2,
PERCENTILE_CONT(0.5) WITHIN GROUP(ORDER BY M.INDICATOR_VALUE) AS x3,
PERCENTILE_CONT(0.75) WITHIN GROUP(ORDER BY M.INDICATOR_VALUE) AS x4,
PERCENTILE_CONT(0.9) WITHIN GROUP(ORDER BY M.INDICATOR_VALUE) AS x5,
PERCENTILE_CONT(0.95) WITHIN GROUP(ORDER BY M.INDICATOR_VALUE) AS x6
FROM (SELECT T.SUPPLIER_CODE SELLER_CODE,
T.CUSTOMER_CODE BUYER_CODE,
max(T.CUSTOMER_NAME) BUYER_NAME,
max(T.SUPPLIER_NAME) SELLER_NAME,
months_between(sysdate, min(t.order_date)) INDICATOR_VALUE
FROM T_DT_SALE_INFO T
GROUP BY T.SUPPLIER_CODE, T.CUSTOMER_CODE) M
GROUP BY M.SELLER_CODE) x;
uj5u.com熱心網友回復：
急急急！求助各位大神！轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/73681.html
標籤：MySQL