Skip to content
Advertisement

How to select max and min of 1 column based on other 2 columns?

I’m trying to get the max and min date values in column C based on the (column A, column B) unique pair combinations.

Suppose I have a table like:

The output I want to get is:

My attempt query has been taking 20 mins to run with no output yet (just tried to get max date from column C for now):

Advertisement

Answer

Just use two conditions:

User contributions licensed under: CC BY-SA
5 People found this is helpful
Advertisement