Returning the ‘last’ row of each ‘group by’ in MySQL

by

Try this query –

SELECT t1.* FROM foo t1
  JOIN (SELECT uid, MAX(id) id FROM foo GROUP BY uid) t2
    ON t1.id = t2.id AND t1.uid = t2.uid;

Then use EXPLAIN to analyze queries.

SELECT t1.* FROM foo t1
  LEFT JOIN foo t2
    ON t1.id < t2.id AND t1.uid = t2.uid
WHERE t2.id is NULL;

More Related Contents:

  1. Using LIMIT within GROUP BY to get N results per group?
  2. Error related to only_full_group_by when executing a query in MySql
  3. SELECT list is not in GROUP BY clause and contains nonaggregated column …. incompatible with sql_mode=only_full_group_by
  4. MySQL Query GROUP BY day / month / year
  5. MySQL order by before group by
  6. Group by clause in mySQL and postgreSQL, why the error in postgreSQL?
  7. Grouping into interval of 5 minutes within a time range
  8. Retrieving the last record in each group – MySQL
  9. MySQL – Selecting a Column not in Group By
  10. Mysql query to dynamically convert rows to columns
  11. MySQL “Group By” and “Order By”
  12. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  13. MySQL – Control which row is returned by a group by
  14. SQL Query to get column values that correspond with MAX value of another column?
  15. MySQL Order before Group by
  16. MySQL Group By and Sum total value of other column
  17. What does SQL clause “GROUP BY 1” mean?
  18. Using ORDER BY and GROUP BY together
  19. MySQL – Fetching lowest value
  20. ORDER BY date and time BEFORE GROUP BY name in mysql
  21. How to select the first row for each group in MySQL?
  22. Converting SELECT DISTINCT ON queries from Postgresql to MySQL
  23. MySQL GROUP BY DateTime +/- 3 seconds
  24. Sum results of a few queries and then find top 5 in SQL
  25. Select all months within given date span, including the ones with 0 values
  26. sql group by versus distinct
  27. MySQL Group By Hours
  28. MySQL cumulative sum grouped by date
  29. Select only last value using group by at mysql
  30. mysql count group by having

Leave a Comment