MySQL combine columns into rows

Question

I have run a SUM query to achieve the following 2 columns and rows:

sum1 | sum2
10     20

The query I ran was the following:

SELECT SUM(minutes) as "sum1", SUM(hoursWorked) AS "sum2"
FROM  entries
JOIN  employees on employeeID = employees.userID 
WHERE YEARWEEK(dateCreated) = YEARWEEK(NOW()) 
ORDER BY employeeID;

I want to combine the values into one column, to get the following:

sums
10
20

A bit lost on how to start with this. Searching has resulting in Concat which obviously wont work.

Can anyone help suggest a method to do this, or the correct function I should be searching for?

EDIT: As suggestions below, I resolved this by doing the following:

SELECT SUM(minutes) as "sum1"
FROM   entries
JOIN   employees on employeeID = employees.userID 
WHERE  YEARWEEK(dateCreated) = YEARWEEK(NOW())
UNION
SELECT SUM(hoursWorked) AS "sum2"
FROM   entries
JOIN   employees on employeeID = employees.userID 
WHERE  YEARWEEK(dateCreated) = YEARWEEK(NOW())

Mansoor · Accepted Answer · 2017-04-28 05:33:02Z

3

Use UNION ALL method :

SELECT sum1 Sums 
FROM your_tablename   
UNION ALL
SELECT sum2 Sums
FROM your_tablename

answered Apr 28, 2017 at 5:33

Mansoor

4,1921 gold badge19 silver badges27 bronze badges

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

3 Comments

Jim Dover Over a year ago

thanks! I have already run a query to return sum1 and sum2, from two tables. Can I use UNION ALL in the same query?

Mansoor Over a year ago

@JimDover,Yes it is possible UNION ALL in query.which table contain minutes & which table contain hoursWorked

Jim Dover Over a year ago

Thanks!!! I resolved this - I edited my post with the solution also. Thank you for your help!

Naresh Yadav · Accepted Answer · 2017-04-28 05:39:14Z

2

I think what you are looking for is UNION operation might help you.

Please take a look at this resource : W3SCHOOLS_UNION

answered Apr 28, 2017 at 5:39

Naresh Yadav

7137 silver badges18 bronze badges

Collectives™ on Stack Overflow

MySQL combine columns into rows

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related