SELECT all Values from a row with distinct values from a column

Question

id | order_id | tracking | status | update_time

Table Name : ndc

1 100204835 124124304 0 2017-06-29 00:00:00

2 100204874 124104482 0 2017-06-29 00:00:00

3 100204835 124124304 0 2017-06-29 00:00:00

I need to SELECT all values (id,order_id,tracking_no) from ndc where order_id should be unique as there might be duplicate values.

The result should output all values in the row as I need to use them further.

For Ex. In the above table order_id 100204835 is duplicate.

try `DISTINCT` after SELECT. Example: `SELECT *, DISTINCT order_id FROM table` — Murad Hasan, Jun 29 '17 at 10:20
but that depends if you want data of a single row regardless of importance of second data of second row — Rahul, Jun 29 '17 at 10:22

score 1 · Answer 1 · answered Jun 29 '17 at 10:30

1

Try this : Select * from ndc group by order_id;

answered Jun 29 '17 at 10:30

Raju Singh

455
1
6
15

score 0 · Answer 2 · edited Jun 29 '17 at 13:14

0

use this

Select * from table group by order_id;

edited Jun 29 '17 at 13:14

Sagar V

12,158
7
41
68

answered Jun 29 '17 at 10:26

Babuji

1

This Doesn't work! It lists 2 rows if their are two same order_id – Alpha Jul 06 '17 at 13:54

Reena Mori · Answer 3 · 2017-06-29T13:18:10.703

0

SELECT DISTINCT order_id,id,tracking_no FROM ndc;

also you can use it for distinct on multiple column

SELECT DISTINCT order_id  FROM ndc
UNION 
SELECT DISTINCT id  FROM ndc
UNION
SELECT DISTINCT tracking_no FROM ndc

edited Jun 29 '17 at 13:18

answered Jun 29 '17 at 10:27

Reena Mori

647
6
15

Murad Hasan · Answer 4 · 2017-06-29T11:13:24.663

0

You need to use DISTINCT with a field name and specifying other fields.

SQL: SELECT DISTINCT order_id, id,tracking,status,update_time FROM table

For more continent answer please follow- MySQL - SELECT all columns WHERE one column is DISTINCT

edited Jun 29 '17 at 11:13

answered Jun 29 '17 at 10:28

Murad Hasan

9,565
2
21
42

RïshïKêsh Kümar · Answer 5 · 2017-06-29T14:14:03.980

0

QUERY:

  SELECT id,order_id,tracking_no,status,update_time, DISTINCT order_id FROM ndc;

or You Can Use Simple group by order_id;

Syntax: select * from table_name group by field_name;

NOTE: A DISTINCT and GROUP BY usually generate the same query plan, so performance should be the same across both query constructs.

edited Jun 29 '17 at 14:14

answered Jun 29 '17 at 11:02

RïshïKêsh Kümar

4,734
1
24
36

No, this is even listing duplicate records. – Alpha Jul 06 '17 at 11:59

Khan M · Answer 6 · 2018-02-08T18:49:30.477

0

none of the answers worked for me so here is one that i got working. use group bu on col4 while taking max values of other columns

select max(col1) as col1,max(col2) as col2,max(col3) as col3
  , col4
  from 
    table1
  group by col4

edited Feb 08 '18 at 18:49

answered Feb 08 '18 at 18:41

Khan M

415
3
17

SELECT all Values from a row with distinct values from a column

6 Answers6