Skip to content
View hackimov's full-sized avatar
🏠
Working from home
🏠
Working from home
  • UFC COMPANY LTD
  • Russia

Block or report hackimov

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Please don't include any personal information such as legal names or email addresses. Maximum 100 characters, markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse

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