MS SQL 挑战问题
- WBOY原創
- 2016-06-07 17:43:53802瀏覽
SELECT T. ROW , T.PRODUCT_NAME, T.SALE_AMOUNT, T.SUM_RAT FROM (,T.PRODUCT_NAME,T.SALE_AMOUNT,( SELECT SUM (SALE_AMOUNT) SUM_SALE FROM TEST WHERE T.SALE_AMOUNT = SALE_AMOUNT) / L.SALE_AMOUNT AS SUM_RAT FROM TEST T, ( SELECT SUM (SALE_AMOUNT
SELECT T.ROW, T.PRODUCT_NAME, T.SALE_AMOUNT, T.SUM_RAT FROM ( , T.PRODUCT_NAME, T.SALE_AMOUNT, (SELECT SUM(SALE_AMOUNT) SUM_SALE FROM TEST WHERE T.SALE_AMOUNT AS SUM_RAT FROM TEST T, (SELECT SUM(SALE_AMOUNT) AS SALE_AMOUNT FROM TEST) L ) T WHERE SUM_RAT
，美国服务器，服务器空间，香港服务器陳述：
本文內容由網友自願投稿，版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容，請聯絡admin@php.cn