aggregate functions - MAX funtion in SQL

Question

I need to query a table to extract maximum values of purchases in any month. However, if there are 2 months with both having the maximum number of purchases, the query should return both. MAX function only returns one of them. How do I pull both or more if available

question from:https://stackoverflow.com/questions/65841626/max-funtion-in-sql

Answer 1

You can GROUP BY by the month(Do not know the exact names of your columns so I wild guessed):

select max(purchases), month
from db.table
group by month

So you will have something like this(EXAMPLE DATA).

max(purchases)   month
   100           1
   200           2
   150           3
   150           4

etc.