SQL select only rows with max value on a column
At first glance… All you need is a GROUP BY clause with the MAX aggregate function: It’s never that simple, is it? I just noticed you need the content column as well. This is a very common question in SQL: find the whole data for the row with some max value in a column per some group identifier. I heard that … Read more