• parth.patel 9337 - Thursday, March 1, 2018 4:55 PM

    The columns in the table are text - can you please advise how should this be fixed?

    There is not enough information here to give a 'correct' anwser.
    Duplicate data can be 'solved' by using  SELECT DISTINCT ......

    If you are not expecting duplicate rows, first analyse why you are getting the duplicate rows. Very often when you get duplicate data this is an indication that the query is not correct. Analyse first then solve the problem. Using SELECT DISTINCT, will give you distinct rows, but is a bit of a 'last resort' method.

    Ben