Skip to content

Instantly share code, notes, and snippets.

@heylastway

heylastway/Select only rows with max value on a column.sql

Created October 31, 2019 16:42
Show Gist options
  • Save heylastway/02a41c2a3fa7d6fc70858b935548f7cd to your computer and use it in GitHub Desktop.
Save heylastway/02a41c2a3fa7d6fc70858b935548f7cd to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Select only rows with max value on a column.sql
SELECT id, MAX(rev)
FROM YourTable
GROUP BY id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment