I am doing an app on trades. There are multiple commission rates for one trade amount (creating lots of extra data). I am trying to use a function in the script to take the highest commission rate only for each trade. Max function maybe????
Max() makes sense, for example:
max(CommisionRate) as HighestRate,
GROUP BY TradeID;
Retrieving data ...