Getting sum from alias in mysql

Question

This is my sql code

SELECT qty, unitprice, qty * unitprice as Stock FROM item

Form this i want to get the SUM of Stock

Try calculating just the sum using SELECT SUM(qty*unitprice) as stock FROM item. — user2989408
– user2989408, Commented Feb 22, 2014 at 1:51

har07 · Accepted Answer · 2014-02-22 01:57:39Z

2

It is not clear what you are asking here. I'm not sure about the ultimate goal you are trying to achieve, but this will bring you SUM of all qty * unitprice :

SELECT qty, unitprice, SUM(qty * unitprice) as Stock FROM item

And this is literally bring you SUM of Stock :

SELECT SUM(Stock) as SUM_OF_STOCK
FROM 
    (SELECT qty, unitprice, qty * unitprice as Stock 
     FROM item)

If none of above query fit your needs, I think you really need to edit the question and elaborate more on what you are trying achieve.

answered Feb 22, 2014 at 1:57

har07

89.5k12 gold badges87 silver badges143 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Getting sum from alias in mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related