MySQL multiple GROUP BY columns into one column [closed]

Question

Closed. This question needs details or clarity. It is not currently accepting answers.

Want to improve this question? As written, this question is lacking some of the information it needs to be answered. If the author adds details in comments, consider editing them into the question. Once there's sufficient detail to answer, vote to reopen the question.

Closed 11 years ago.

Improve this question

I have query about Group By in Mysql

Looks like my table col1 and col2

1 1
4 6
5 4
2 3
1 9
2 1
3 2

Need to display the output like this

col1&col2 and count(col1&col2)

can any one suggest to get the above result as output using mysql query?

Thanks in advance

You mean - count in 2 colums? Like '1' is present 4 times, so it's 4. '2' occur 3 times, so it's 3. Right? Does order important for you? — Tigran
– Tigran, Commented Jan 21, 2014 at 5:01

Gilberg · Accepted Answer · 2014-01-21 05:10:17Z

2

SELECT my_table.col, count(my_table.col)
FROM 
(
   SELECT col1 as col FROM your_table
   UNION ALL
   SELECT col2 as col FROM your_table
) AS my_table
GROUP BY col

Don't forget the table names and you have to have a table alias. I tried to make this a comment but didn't have enough points to comment. Just an addendum to @tigran

answered Jan 21, 2014 at 5:10

Gilberg

2,5704 gold badges34 silver badges44 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:21:00Z

2

SELECT some_table.col, count(some_table.col)
FROM 
(
SELECT col1 as col FROM table
UNION ALL
SELECT col2 as col FROM table
)  AS some_table
GROUP BY col

Something like this - MySQL COUNT() multiple columns

edited May 23, 2017 at 12:21

CommunityBot

11 silver badge

answered Jan 21, 2014 at 5:06

Tigran

1,0773 gold badges15 silver badges31 bronze badges

2 Comments

serakfalcon Over a year ago

sqlfiddle.com/#!2/fff3d/5 fiddle for good measure, you beat me to it while I was building this

Tigran Over a year ago

Thanks to @Gilberg, table alias is required.

Magendiran · Accepted Answer · 2014-01-21 08:08:34Z

0

Finally i got the solution with the help of you all

SELECT col, count(col) FROM ( SELECT col1 as col FROM table_name UNION ALL SELECT col2 as col FROM table_name ) AS temp_table GROUP BY col ORDER BY col

Thanks to all of you @ Marc B, @Tigran, @serakfalcon and @Gilberg

answered Jan 21, 2014 at 8:08

Magendiran

517 bronze badges

Collectives™ on Stack Overflow

MySQL multiple GROUP BY columns into one column [closed]

col1&col2 and count(col1&col2)

3 Answers 3

Comments

2 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

col1&col2 and count(col1&col2)

3 Answers 3

Comments

2 Comments

Comments

Linked

Related