[Q]How can I qurey data without duplicate

Discussion in 'MySQL' started by Eng_A_Moktar, Nov 13, 2009.

0
  1. #1
    How can I qurey data without duplicate

    I have a table that contain data, some of these data are the same
    I wanna qurey these data and echo back without duplications
    is it possible
     
    Eng_A_Moktar, Nov 13, 2009 IP
  2. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #2
    Complete rows are duplicate or just a column? You can use DISTINCT or GROUP BY to eliminate duplicate records.
     
    mwasif, Nov 13, 2009 IP
  3. solarpanelsdirect

    solarpanelsdirect Peon

    Messages:
    152
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    SELECT DISTINCT result FROM table WHERE condition='yourcondition'
     
    solarpanelsdirect, Dec 20, 2009 IP