Menu
I have the following table:
ID NAME TIME 1 A 0 2 A 3 3 B 1
I am using the query below which produces:
SELECT * FROM `table` GROUP BY `NAME`
ID NAME TIME 1 A 0 3 B 1
And I want use GROUP BY to generate a result like this (discount sort by the TIME column):
ID NAME TIME 2 A 3 3 B 1
270
Both GROUP BY and ORDER BY are clauses (or statements) that serve similar functions; that is to sort query results. However, each of these serve very different purposes; so different in fact, that they can be employed separately or together.
In MySQL, GROUP BY is used for sorting, so the server may also apply ORDER BY optimizations to grouping.
It is used to arrange similar data into the group. The GROUP BY clause follows the WHERE clause and comes before the ORDER BY clause.
The general syntax for selecting values and sorting them is: SELECT column_name, column_name FROM table_name ORDER BY column_name ASC, column_name DESC; Note that ORDER BY() will automatically sort the returned values in ascending order so the use of the ASC keyword is optional.
SELECT NAME, MAX(TIME) as TIME
FROM table
GROUP BY time
ORDER BY time DESC
select * from (select * from table order by TIME DESC) t group by NAME
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
