Returning a Max Result in a column

Steve Smith

CASE
WHEN D's % of AOR = MAX(D's % of AOR) THEN 1
ELSE 0
END

Some how this is returning the total for the column. All values are returning a 1.

GrantSmith

Try converting to a window function so that each row is compared to a single value instead of the aggregated value.

CASE WHEN `D's % of AOR` = MAX(`D's % of AOR`) OVER () THEN 1
ELSE 0
END

Steve Smith

Used this exact code to return the max date, however, with this code all values are retuning 0.