mardi 26 juillet 2016

SQL to detect adjacent duplicate rows (duplicates indicated by values in subset of columns)?

I'm trying to hunt down a potential bug in my application, and I'd like to see if there are duplicate events recorded for a user, which would be evidenced by duplicate data in two columns, user and value whereas the other columns could have slightly different meta data. Is there a way to identify such duplicates in a single SQL query?

Aucun commentaire:

Enregistrer un commentaire