Sunday, 11 August 2013

MYSQL select dublicated values where 2 or 3 column values are reapeated

MYSQL select dublicated values where 2 or 3 column values are reapeated

Due to Ajax bug I end up having lots of repeated data, where the
combination of 2 columns need to be unique. I simplified the table to name
and surname for this question.
Imagine in Table users how can I get the id where name + surname is
duplicated. I have attached a picture.
Thank you.

No comments:

Post a Comment