Hi,
I need some help with the query to find duplicate rows on specific value. I have tried many queries, but I can't find it. For now I have this.
My sql structure:
id INT(11) NOT NULL AUTO_INCREMENT,
vrijeme TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
pocetni_broj VARCHAR(55) DEFAULT NULL,
zamjenski_broj VARCHAR(55) DEFAULT NULL,
glavni_broj VARCHAR(55) DEFAULT NULL,
postoji_zamjena INT(1) DEFAULT NULL,
PRIMARY KEY (id)
And my query is:
SELECT *
FROM zamjene_brojeva
GROUP BY glavni_broj
HAVING COUNT(glavni_broj) > 1
Thta is giving me all duplicate values in table. But how do I find duplicate values where column glavni_broj has value 966 45 19-68? I know that there is 4 rows with that value in glavni_broj. I have tried to put Where in that, but than query fails.
Any ideas how to do it?