Query Help on Group By Address

[katekis]

I need help on a query. I am trying to create a mail list.

Below is the query, sometimes there are more then one households living at the same address.

if there are multiple headOfHouse at the same address I want only the one with min(HeadofHouse).

Select HeadofHouse
, FullName = cfmr_first_name + ' ' + cfmr_last_name
, addr1, addr2, city, state, zip
FROM ViewMarketing_StandardExclusions

 

[gbaughma]

What about a select distinct?

Something along

SELECT DISTINCT addr1, addr2, city, state, zip, cfmr_first_name + ' ' + cfmr_last_name AS Fullname
FROM ViewMarketing_StandardExclusions
GROUP BY addr1
ORDER BY Fullname

*Disclaimer* I have not tried this... but it might give you a step in the right direction. You may not need to use DISTINCT...


Just my 2¢

"What the captain doesn't realize is that we've secretly replaced his Dilithium Crystals with new Folger's Crystals."

--Greg

http://parallel.tzo.com

 

[markros]

Please check these two links that apply to your problem:
Including an Aggregated Column's Related Values
Including an Aggregated Column's Related Values - Part 2

PluralSight Learning Library