Group by minimum value in one field while selecting distinct rows

by

How about something like:

SELECT mt.*     
FROM MyTable mt INNER JOIN
    (
        SELECT id, MIN(record_date) AS MinDate
        FROM MyTable
        GROUP BY id
    ) t ON mt.id = t.id AND mt.record_date = t.MinDate

This gets the minimum date per ID, and then gets the values based on those values. The only time you would have duplicates is if there are duplicate minimum record_dates for the same ID.

More Related Contents:

  1. Is there any difference between GROUP BY and DISTINCT
  2. SQL Group by & Max
  3. Selecting all corresponding fields using MAX and GROUP BY
  4. Huge performance difference when using GROUP BY vs DISTINCT
  5. SQL not a single-group group function
  6. How do I (or can I) SELECT DISTINCT on multiple columns?
  7. Using group by on multiple columns
  8. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  9. Concat groups in SQL Server [duplicate]
  10. Ms Access Query: Concatenating Rows through a query
  11. Simple Query to Grab Max Value for each ID
  12. SQL query for finding records where count > 1
  13. What’s the best way to select the minimum value from several columns?
  14. GROUP BY + CASE statement
  15. SQL Query to get column values that correspond with MAX value of another column?
  16. SQL GROUP BY CASE statement with aggregate function
  17. How to get second largest or third largest entry from a table [duplicate]
  18. Mysql: how to select groups having certain values?
  19. MySQL #1140 – Mixing of GROUP columns
  20. SQL Server Update Group by
  21. How can I group time by hour or by 10 minutes?
  22. Produce DISTINCT values in STRING_AGG
  23. sql group by only rows which are in sequence
  24. MySQL GROUP BY behavior
  25. Conditional SQL count
  26. SQL: How do you select only groups that do not contain a certain value?
  27. SQL distinct for 2 fields in a database
  28. How to select records without duplicate on just one field in SQL?
  29. SQL query to group by day
  30. How to do a case sensitive GROUP BY?

Leave a Comment