Stack Exchange Network
Stack Exchange network consists of 181 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this community
Anybody can ask a question
The best answers are voted up and rise to the top
for each row I need to select highest value from 3 columns, somethings like below. However, for some reason I can't do this. Please help.
1,26911 gold badge44 silver badges1717 bronze badges
MAX(Clicks_Syria) as syria,
MAX(Clicks_Ukraine) as ukraine,
MAX(Clicks_Afghanistan) as afghanistan
GROUP BY SubscriberKey
answered Jan 26 at 11:34
13.7k22 gold badges1919 silver badges5151 bronze badges