How to get the latest record in each group using GROUP BY? [duplicate]

by

You should find out last timestamp values in each group (subquery), and then join this subquery to the table –

SELECT t1.* FROM messages t1
  JOIN (SELECT from_id, MAX(timestamp) timestamp FROM messages GROUP BY from_id) t2
    ON t1.from_id = t2.from_id AND t1.timestamp = t2.timestamp;

More Related Contents:

  1. SQL select only rows with max value on a column [duplicate]
  2. Using LIMIT within GROUP BY to get N results per group?
  3. ROW_NUMBER() in MySQL
  4. Get top n records for each group of grouped results
  5. How can I SELECT rows with MAX(Column value), PARTITION by another column in MYSQL?
  6. Get records with max value for each group of grouped SQL results
  7. Retrieving the last record in each group – MySQL
  8. Select row with most recent date per user
  9. Get the latest date from grouped MySQL data
  10. In SQL, how to select the top 2 rows for each group
  11. Get most recent row for given ID
  12. Using ORDER BY and GROUP BY together
  13. How to select the most recent set of dated records from a mysql table
  14. SELECT query return 1 row from each group
  15. How to select data where a field has a min value in MySQL?
  16. How do I limit the number of rows per field value in SQL?
  17. Delete the entire content of all table in a Database [closed]
  18. Delete all Duplicate Rows except for One in MySQL? [duplicate]
  19. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  20. How to get the difference in years from two different dates?
  21. Error Code: 1406. Data too long for column – MySQL
  22. Using Count to find the number of occurrences
  23. Is there any reason to worry about the column order in a table?
  24. Checking a table for time overlap?
  25. Does mysql have the equivalent of Oracle’s “analytic functions”?
  26. MYSQL select DISTINCT values in two columns
  27. SQL (MySQL) vs NoSQL (CouchDB) [closed]
  28. MySQL update statement to store ranking positions
  29. How to convert a varchar column type to date type without losing the dates
  30. MySQL Multiple Joins in one query?

Leave a Comment