ORDER BY date and time BEFORE GROUP BY name in mysql

by

Another method:

SELECT * 
FROM (
    SELECT * FROM table_name
    ORDER BY date ASC, time ASC 
) AS sub
GROUP BY name

GROUP BY groups on the first matching result it hits. If that first matching hit happens to be the one you want then everything should work as expected.

I prefer this method as the subquery makes logical sense rather than peppering it with other conditions.

More Related Contents:

  1. MySQL order by before group by
  2. MySQL “Group By” and “Order By”
  3. Select the 3 most recent records where the values of one column are distinct
  4. MySQL – Control which row is returned by a group by
  5. MySQL: Sort GROUP_CONCAT values
  6. MySQL Order before Group by
  7. ORDER BY alphabet first then follow by number
  8. Using LIMIT within GROUP BY to get N results per group?
  9. Group by clause in mySQL and postgreSQL, why the error in postgreSQL?
  10. How to find similar results and sort by similarity?
  11. Retrieving the last record in each group – MySQL
  12. MySQL – Selecting a Column not in Group By
  13. Mysql query to dynamically convert rows to columns
  14. Ordering by specific field value first
  15. SQL order string as number
  16. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  17. In SQL, how to select the top 2 rows for each group
  18. Order by COUNT per value
  19. SQL Query to get column values that correspond with MAX value of another column?
  20. MySQL – Fetching lowest value
  21. SQL Order By Count
  22. MySQL: How do I join same table multiple times?
  23. Converting SELECT DISTINCT ON queries from Postgresql to MySQL
  24. MySQL – ORDER BY values within IN()
  25. Mysql: Order by like?
  26. MySQL Group By Hours
  27. MySQL cumulative sum grouped by date
  28. MYSQL Select One Random record from each Category
  29. mysql order by, null first, and DESC after
  30. Default sort-ordering in MySQL (ALTER TABLE … ORDER BY …;)

Leave a Comment