注册

mysql语句转达梦语句

富贵 2024/08/07 455 10

SELECT
aa.FOUND_DATE AS foundDate,
aa.entNum
FROM
(
SELECT
FOUND_DATE,
@total := @total + total1 AS entNum
FROM
(
SELECT YEAR
( FOUND_DATE ) AS FOUND_DATE,
sum( 1 ) AS total1
FROM
zszx.EM_ENTPRISE_MASTER
WHERE
ENABLED = 1
GROUP BY
YEAR ( FOUND_DATE )
) AS temp,
( SELECT @total := 0 ) AS T1
ORDER BY
FOUND_DATE
) aa
WHERE
aa.FOUND_DATE > YEAR (
now())-5

回答 0
暂无回答
扫一扫
联系客服