Getting unique results

[bnashenas1984]

Hi everyone
You see an example table below.. I'm trying to get one of each (day) using DISTINCT command...

+---------------------------+
|    day       |  weather   |
+---------------------------+
|   Monday     |    Good    |
|   Tuesday    |    Bad     |
|   Wednsday   |    worst   |
|   Tuesday    |    Good    |
|   Wednsday   |    Bad     |
+---------------------------+
 

Here's the code :

SELECT DISTINCT day FROM mytable 
 

Actually it works but the problem is that this one only returns the day column.. but i need to get both columns and if i use this code :

SELECT DISTINCT day,weather FROM mytable 
 

Then it doesn't return the same result becuase DISTINCT takes effect on both columns

Here's the result I'm expecting:

+---------------------------+
|    day       |  weather   |
+---------------------------+
|   Monday     |    Good    |
|   Tuesday    |    Bad     |
|   Wednsday   |    worst   |
+---------------------------+
 

Thanks

[mwasif]

Use GROUP BY instead of DISTINCT.

SELECT `day`, weather  FROM mytable GROUP BY `day`

The use of GROUP_CONCAT() may be of you interest.

SELECT `day`, GROUP_CONCAT(weather)  FROM mytable GROUP BY `day`

[bnashenas1984]

It's working now

Thank you so much

[mwasif]

You are welcome, post back whenever you need help.