I have joined together tables but the data has some duplicates by design. To simple the example below

User address
------------

User1 100 main st.

User1 999 everyone St.

User2 400 elm st.

User2 999 everyone St.

User3 300 pine st.

User3 999 everyone St.

User4 999 everyone St.

How would I get every user only once and the one address getting the preferred address (instead of the generic 999 everyone st. that everyone gets).

User1 100 main st.

User2 400 elm st.

User3 300 pine st.

User4 999 everyone St.