Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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????
-Kevin
Hi Kevin,
Max() makes sense, for example:
SELECT
max(CommisionRate) as HighestRate,
TradeID
FROM Trades
GROUP BY TradeID;
Regards,
Michael