top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How to remove duplicate columns values in MySQL?

+1 vote
How to remove duplicate columns values in MySQL?
posted Jun 10, 2014 by Amanpreet Kaur

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

In MySql we need to use DISTINCT statement to get distinct (unique) values .

e.g :

SELECT DISTINCT column_name FROM table_name ;

answer Jun 12, 2014 by Mohit Sharma
Similar Questions
+1 vote

Joiner using how to get three tables value fetching from single query.

+1 vote

I need to select some data from a table where a column is not a numerical value but can't seem to get the right syntax for this.

Basically we need to do something like this:

SELECT * FROM tablename WHERE column_name (IS NOT A NUMERIC VALUE)

what is the correct syntax to accomplish this?