Results 1 to 2 of 2

Thread: Distinct Row Query

  1. #1
    ken Guest

    Distinct Row Query

    I need help with a query on a single table.

    The table in name, date, ss# and I need to get unique rows, but there can me many ss# to each date. I need to get the max date for each unique ss#.

    Select distinct name, date, ss#

    returns all rows, because dates are different, but I need to have the results contain all three columns of information.

    Thanks for the help,

    -Ken

  2. #2
    Gregory Guest

    Distinct Row Query (reply)

    select ssn#, max(<your date field>)
    from <table name>
    group by ssn#

    ------------
    ken at 6/18/99 4:03:24 PM

    I need help with a query on a single table.

    The table in name, date, ss# and I need to get unique rows, but there can me many ss# to each date. I need to get the max date for each unique ss#.

    Select distinct name, date, ss#

    returns all rows, because dates are different, but I need to have the results contain all three columns of information.

    Thanks for the help,

    -Ken

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •