#SQL #MAXIMUM #WITHOUT_GROUP_BY #SPEED #QUERY

GROUP_MAXIMUM.SQL

SELECT maintable.*
FROM TABLE_NAME maintable
LEFT OUTER JOIN TABLE_NAME temporarytable
 ON maintable.GROUPING_BY_COLUMN = temporarytable.GROUPING_BY_COLUMN
 AND maintable.COLUMN_WHERE_THE_MAXIMUM_IS_NEEDED < temporarytable.COLUMN_WHERE_THE_MAXIMUM_IS_NEEDED
WHERE temporarytable.COLUMN_WHERE_THE_MAXIMUM_IS_NEEDED IS NULL
ORDER BY PRIMARY_KEY_COLUMN DESC
LIMIT 50;