General information
Category:
Coding, syntax & commands
Title:
Sum, Average, Highest, Lowest
I am needing to get the total amount on a SalesAmt field for each sales person, and using a SELECT sum statement I am having no problem doing that.
Here is the question: is there also a way to get the smallest amount, and the largest amount as well for each sales person?
Thanks,
Mel Cummings
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only