vendredi 27 mars 2015

MYSQL Get column group with different values on other column


I have the following table:



week status
------- ------
102014 1
102014 1
102014 1
112014 2
112014 2
112014 2
122014 2
122014 0
122014 0
132014 1
132014 1
132014 1
142014 2
142014 2
142014 2


How can I get 122014 which has different values on status?





Aucun commentaire:

Enregistrer un commentaire