Pinned Loading

1. #SQL #MAXIMUM #WITHOUT_GROUP_BY #SPE... #SQL #MAXIMUM #WITHOUT_GROUP_BY #SPEED #QUERY

   1

   SELECT maintable.*

   2

   FROM TABLE_NAME maintable

   3

   LEFT OUTER JOIN TABLE_NAME temporarytable

   4

    ON maintable.GROUPING_BY_COLUMN = temporarytable.GROUPING_BY_COLUMN

   5

    AND maintable.COLUMN_WHERE_THE_MAXIMUM_IS_NEEDED < temporarytable.COLUMN_WHERE_THE_MAXIMUM_IS_NEEDED