SQL Query to get column values that correspond with MAX value of another column?

by

I would try something like this:

SELECT
   s.video_id
   ,s.video_category
   ,s.video_url
   ,s.video_date
   ,s.video_title
   ,short_description
FROM videos s
   JOIN (SELECT MAX(video_id) AS id FROM videos GROUP BY video_category) max
      ON s.video_id = max.id

which is quite faster that your own solution

More Related Contents:

  1. MySQL “Group By” and “Order By”
  2. mysql count group by having
  3. Calculate Average of the largest values in multiple columns
  4. SQL select only rows with max value on a column [duplicate]
  5. Using LIMIT within GROUP BY to get N results per group?
  6. Error related to only_full_group_by when executing a query in MySql
  7. SELECTING with multiple WHERE conditions on same column
  8. MySQL Query GROUP BY day / month / year
  9. Group by clause in mySQL and postgreSQL, why the error in postgreSQL?
  10. Strange duplicate behavior from GROUP_CONCAT of two LEFT JOINs of GROUP_BYs
  11. Grouping into interval of 5 minutes within a time range
  12. Retrieving the last record in each group – MySQL
  13. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  14. Mysql query to dynamically convert rows to columns
  15. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  16. Is there ANY_VALUE capability for mysql 5.6?
  17. Group mysql query by 15 min intervals
  18. In SQL, how to select the top 2 rows for each group
  19. MySQL Group By and Sum total value of other column
  20. Is it possible to GROUP BY multiple columns using MySQL?
  21. Using Count to find the number of occurrences
  22. What does SQL clause “GROUP BY 1” mean?
  23. Using ORDER BY and GROUP BY together
  24. MySQL: How do I join same table multiple times?
  25. GROUP BY – do not group NULL
  26. Selecting all corresponding fields using MAX and GROUP BY
  27. How to select data where a field has a min value in MySQL?
  28. How to SELECT by MAX(date)?
  29. MySQL Group By Hours
  30. SQL query with avg and group by

Leave a Comment