D
D
dienerie2022-04-08 10:05:32
MySQL
dienerie, 2022-04-08 10:05:32

How to display duplicates in two columns?

You need to display a list of duplicates.
Those. There are two columns, you need to find identical values ​​in them.
Example:

Column1 Column2
123 235
768 178
127 758
556 556
184 185
997 997

Also, additionally
how to add to this find values ​​that are identical in characters, but in the first column or second contain spaces, unlike the other column? Is this done with a regex embedded in sql?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question