Group by two column in mysql table

Question

I want group this table

column1|    date

A      |2016-07-01
A      |2016-07-01
A      |2016-07-02
C      |2016-07-01
C      |2016-07-02

and i need get the result something like this

column1 |   date
A       |2016-07-01
A       |2016-07-02
C       |2016-07-01
C       |2016-07-02

This is what i did to sort the table to get the result like above table

SELECT * FROM table1 GROUP BY column1 and date

but not working . How can i do that ?

You've seen the other threads on this topic? http://stackoverflow.com/questions/2421388/using-group-by-on-multiple-columns — chris85, Jul 09 '16 at 18:52

score 1 · Answer 1 · answered Jul 09 '16 at 18:54

1

Based on your desired results ... It appears that you are looking to get all distinct combinations of two columns

There are 2 ways to do that :

answered Jul 09 '16 at 18:54

objectNotFound

i missed the distinct . first one is working thanks – ARUN Madathil Jul 09 '16 at 19:04
@ARUNMadathil If the answer works please accept it. http://meta.stackexchange.com/questions/5234/how-does-accepting-an-answer-work – chris85 Jul 09 '16 at 19:06

score 1 · Answer 2 · answered Jul 09 '16 at 19:10

1

For the result show in your question you should use

SELECT column1, `date`  FROM table1 GROUP BY  `date`
order by column1, `date`

answered Jul 09 '16 at 19:10

ScaisEdge

2 Answers2