mysql remove duplicate data if sequential

Asked Mar 21 '21 at 07:43

Active Mar 21 '21 at 09:45

Viewed 32 times

I have previously made a question here select only when different value and it has been answered. Now my question is how to remove double data so that the usual select query can produce the desired data

For example I have this records:

id	name	price
1	book	5
2	lamp	7
3	lamp	7
4	book	5
5	book	5

the result I want is:

id	name	price
1	book	5
2	lamp	7
4	book	5

asked Mar 21 '21 at 07:43

Faiz

2

[Edit] the question and show what you have tried and explain, in detail, what the problem is with it (error messages, unexpected result, etc.). – sticky bit Mar 21 '21 at 08:04
How is this question different than your previous one? – forpas Mar 21 '21 at 10:00
Your sample data this time is exactly the same as the previcious one. Is it really correct? – etsuhisa Mar 21 '21 at 12:53

mysql remove duplicate data if sequential

0 Answers0

Linked