I am in the middle of creating an SQL in SFMC. I have three attributes in the source Data Extension:
MAX (yes, the name is weird, but it is not the point...).
What I want to achieve is to move to the target data extension all three attributes, but only the record with the highest MAX attribute value (128614.150). It is the last record (see the photo attached).
So the target DE would have only one record:
GlobalID, CategoryDescription, MAX
1000047634, Category 8, 128614.150
Thank you very much for your help!