how to set null when find dupplicate value in mysql

Sep 9 '20 Comments: 1 Answers: 1

0

i have join the table like this

+--------------+----------------------+------------+-------------+
| sales.cus_id |  customers.name      |sales.qty   |sales.price  |
+--------------+----------------------+------------+-------------+
| 1            |  jamal               |    20      |    26       | 
+--------------+----------------------+------------+-------------+
| 1            |  jamal               |    30      |    40       | 
+--------------+----------------------+------------+-------------+
| 1            |  jamal               |    25      |    50       | 
+--------------+----------------------+------------+-------------+
| 1            |  jamal

…

Open Full Question