MySQLHow to select records without duplicate

Question

Table Name: Order

Columns: ID & NAME & DATE

With the following records :

1 | starone | 2016
1 | starone | 2016
2 | mogaone | 2017
9 | starone | 2016

And am looking to only select data without getting duplicates :

Expected OUTPUT

1 | starone | 2016
2 | mogaone | 2017
9 | starone | 2016

So which query shall i use?

How come you have duplicates in the first place, is `ID` not a primary key? — HoneyBadger, Nov 20 '17 at 15:27
@jarlh `DISTINCT` OR `DISTINCTROW` , are `DISTINCT` will only show the duplicates record for only one time based on those 3 columns if matching in one entry ? — Brooke Peaden, Nov 20 '17 at 15:28
Here is some [documentation](https://dev.mysql.com/doc/refman/5.7/en/select.html)! — Drag and Drop, Nov 20 '17 at 15:29
Forget about DISTINCTROW, it's just a silly MySQL synonym for ANSI SQL's DISTINCT. — jarlh, Nov 20 '17 at 15:34
In a well-formed table, this situation simply cannot occur. What is your PRIMARY KEY? — Strawberry, Nov 20 '17 at 15:36

BSants · Answer 1 · 2017-11-20T16:36:53.637

Let's see what the documentation shows for us:

The SELECT DISTINCT statement is used to return only distinct (different) values.

Inside a table, a column often contains many duplicate values; and sometimes you only want to list the different (distinct) values.

SELECT DISTINCT column1, column2, ...
FROM table_name;

So, try it:

SELECT DISTINCT ID, NAME, DATE
FROM Order;

1 Answers1