Post reply

select multiple fields where only 2 are distinct?

  • February 28, 2007 at 9:15 am

    #176194

    i would like to select fname, lname, dob, address, city, state, zip

    from my table but only want to return rows for each person (fname, lname) where the address and city are unique.

    how would that query look - i cant seem to piece it together.

  • February 28, 2007 at 11:50 am

    #692385

    can anyone help me out here?

    basically the table is a list of users and their addresses. there are several cases where there are 2 listings for the same name. I basically only want to show 2 listings for a name if the address on the 2 listings is different, suppressing all duplicate name rows that have the same address.

    cant figure out how to do this.

  • February 28, 2007 at 12:42 pm

    #692398

    What is the primary key on your table?  Can you post your table DDL?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply