Answer by amonds ·
Thank you! I am looking for it to show just the men with the highest % commission, in this case 0.15 (decimal as percent). So I can do the exercise where I specify 0.15, but not if I'm just trying for MAX.
Keep in mind I'm a newbie :)
Answer by anthony.green ·
Maximum value, so do you want the total commission for a sales man, or the 1 largest commission.
E.g Sales Man 1 has 2 commissions at $1000 each
Sales Man 2 has 1 commission at $1500
What do you want to see, sales man 1 with a commission of $2000 or sales man 2 with a commission of $1500.
Option 1 for the $2000 result, go look at the aggregate function SUM.
Option 2 for the $1500 result look at TOP and ORDER BY