Every derived table must have its own alias
派生出来的表必须取别名
SELECT
sum( a.exposureMarketcapDiff )
FROM
(
SELECT
new.id,
new.coinId,
ifnull( new.exposureMarketcap, 0 ) - ifnull( old.exposureMarketcap, 0 ) AS exposureMarketcapDiff
FROM
( SELECT id, coin_id AS coinId, exposure_ma...
原创
2021-09-15 16:52:49 ·
81 阅读 ·
0 评论