Partitioning data in script

[#1]

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

[Anonymous]

Hi Kevin,

Max() makes sense, for example:

SELECT

max(CommisionRate) as HighestRate,

TradeID

FROM  Trades

GROUP BY TradeID;

Regards,

Michael