mysql – 在SELECT中重用别名

我想要做的是添加另一个计算的列(cr – dr)

看到你不能在SELECT子句中重用别名,你会怎么去计算总计

    SELECT SUM(b.bet_win * cy.fx_rate )as dr,SUM(b.bet_loss * cy.fx_rate ) as cr,cr+dr as total
    FROM ....
    WHERE ....

SELECT dr,cr,cr + dr as total 
FROM (
    SELECT 
         SUM(b.bet_win * cy.fx_rate ) as dr,SUM(b.bet_loss * cy.fx_rate ) as cr
    FROM ....
    WHERE ....) t;

（编辑：鄂州站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!