Hi again,
is it possible to change the order of GROUP BY.
e.g. i have 3 rows of data all related to unit number 313025 as below
313025 - Red - Yellow - NoData
313025 - Red - Green - Green
313025 Green - Green - Green
When i do a GROUP BY Unit i get the following
313025 - Red - Yellow - NoData
or the fist one in the group that was entered, what...
itnassol
Last Activity: Nov 12 '08, 03:37 PM
Joined: Nov 12 '08
Location:
-
reverse group by in mysql
-
The DISTINCT command with multiple columns
Hi guys,
What i want to do is use a query that will return one of each type regardless of the other in there, for example.
i have a list of unit unit 3131,3132,3133 etc and they have a status attached to them of red, green or yellow.
when i run a select statment on them as below i get the results
unit 3131 - red
unit 3132 - green
unit 3132 - red
i knopw that...
No activity results to display