Simple SQL Problem

Question

Hey...I am in a bind here. I am not much of a programmer but the guy who does the sql at my business is out sick.

If I have a table like this (I am simplifying this a lot but this is where I am stuck).

Name Object   Payment

Joe  A         100
Jan  A         200
Joe  A         300
Ron  A         500
Jan  A         100
Joe  B         200

How do I write a query that would give me:

Joe A    300
Jan A    200
Ron A    500
Joe B    200

Essentially the highest value in the Payment field for each name. Thanks. Sorry if I sound dumb...but I just cant find anything on the internet to help me.

D'Arcy Rittich · Answer 1 · 2010-10-05T00:41:38.197

10

select Name, Object, max(Payment) as MaxPayment
from MyTable
group by Name, Object

edited Oct 05 '10 at 00:41

answered Oct 05 '10 at 00:20

D'Arcy Rittich

167,292
40
290
283

Sorry...i made a change to my question. Good answer though. Sorry...im such a noob. – user466334 Oct 05 '10 at 00:25
@user466334: I revised my answer accordingly. – D'Arcy Rittich Oct 05 '10 at 00:41
Fastest gun ... SO is unfair and that is great news. – Hamish Grubijan Oct 05 '10 at 00:49

score 4 · Answer 2 · answered Oct 05 '10 at 00:27

4

Try:

SELECT Name, Object, MAX(Payment)
FROM   MyTable
GROUP BY Name, Object

answered Oct 05 '10 at 00:27

p.campbell

98,673
67
256
322

score 4 · Accepted Answer · answered Oct 05 '10 at 00:27

4

select Name, Object, max(Payment)
from table
group by Name, Object

answered Oct 05 '10 at 00:27

Peter

12,541
3
34
39

Simple SQL Problem

3 Answers3