MySQL Forums
Forum List  »  Newbie

Tri of field and select only one occur
Posted by: steve austin
Date: March 19, 2024 06:40AM

Hi,

I have this data

a | b | c |
+------+------+------+
| 3 | 1 | 2 |
| 3 | 2 | 1 |
| 3 | 2 | 2 |
| 13 | 4 | 7 |

and i would like to select only on occur from the different field like below
a | b | c |
+------+------+------+
| 3 | 2 | 2 |
| 13 | 4 | 7 |
| 3 | 2 | 1 |

Then the first line (or the second) must dissapear how can i do taht thanks

Options: ReplyQuote


Subject
Written By
Posted
Tri of field and select only one occur
March 19, 2024 06:40AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.