reusing alias in SELECT reusing alias in SELECT sql sql

reusing alias in SELECT


mysql sql database

In SQL Server or Oracle, I'd use a CTE, but since you're using MySQL, you'd use a subquery:

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;

mysql sql database

EDIT: DOES NOT WORK. See comments.Isn't using a user variable faster in this case?

SELECT  @dr:=SUM(b.bet_win * cy.fx_rate ),  @cr:=SUM(b.bet_loss * cy.fx_rate ),   @cr+@dr as total

mysql sql database

You can repeat the calculations in the "total" column.

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

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last