Post reply

Distinct for One Column only

  • January 31, 2013 at 3:08 am

    #288571

    Hi all!

    I currently have a table with the following column names `1` `2` `3` `4` `5` `6` `7` `8` and a select statement with the following;

    SELECT * FROM `streets_eu`

    WHERE `1` ="AND"

    AND `2` != "UND"

    ORDER BY RAND() LIMIT 0,500

    I don't want the query to display duplicate values for col 5 so I thought adding DISTINCT would work but its not working. I also done some research on using PARTITION but its not working. I was wondering if someone can help please!

    Best regards!

  • January 31, 2013 at 6:42 am

    #1582970

    That looks like MySQL code. This is a website dedicated to Microsoft SQL Server. You may find more assistance on StackOverflow or the Oracle product website.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • January 31, 2013 at 6:56 am

    #1582980

    I realized that after posting the question,

    Sorry about that 🙂

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

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