
Selecting a maximum sum from a group
Question: I need to write a query that selects the maximus sum for a group from a list like the one below. Type ValueA 100B 200C 300A 300B 100C 342 The result should be C, 642. I tried “group by,” but I could only get the sums. Answer: You must