Query Help

[JazzMaan]

i have 2 tables:
Individual: has iid, hid (Individual id, household id)
Order_header: iid, order amount

I want the query to return 1 individual per household who has the hightest order amoount

 

[MakeItSo]

Hi!

Try something like this:

SELECT TOP 1 i.[iid], i.[hid], o.[order amount]
FROM [Individual] AS i INNER JOIN [Order_header] AS o
ON i.[iid] = o.[iid]
ORDER BY o.[order amount] DESC;

Cheers,
MakeItSo

[navy]"We had to turn off that service to comply with the CDA Bill."[/navy]
- The Bastard Operator From Hell

 

[markros]

Please take a moment to check these blogs explaining the problem:

Including an Aggregated Column's Related Values
Including an Aggregated Column's Related Values - Part 2


PluralSight Learning Library