Search snippets
Browse Code Answers
FAQ
Usage docs
Log In
Sign Up
Home
Whatever
get row from max
Mat
Programming language:
Whatever
2021-06-29 10:14:55
0
Q:
get row from max
Tamara
Code:
Whatever
2021-06-25 15:13:16
SELECT * FROM t1 WHERE (id,rev) IN ( SELECT id, MAX(rev) FROM t1 GROUP BY id )
0
Tags
get
row
Related
how to get index of max n values in an array
how to find max in array
max element in array
find second max element in array in 1 iteration
max of a dict
find max of countby
New to Communities?
Join the community