budimir Posted October 27, 2015 Share Posted October 27, 2015 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? Quote Link to comment Share on other sites More sharing options...
QuickOldCar Posted October 27, 2015 Share Posted October 27, 2015 Query like this failed? SELECT *FROM zamjene_brojeva WHERE glavni_broj='966 45 19-68'GROUP BY glavni_brojHAVING COUNT(glavni_broj) > 1 Quote Link to comment Share on other sites More sharing options...
budimir Posted October 27, 2015 Author Share Posted October 27, 2015 Query like this failed? SELECT * FROM zamjene_brojeva WHERE glavni_broj='966 45 19-68' GROUP BY glavni_broj HAVING COUNT(glavni_broj) > 1 Yes, it didn't return any results. Quote Link to comment Share on other sites More sharing options...
Solution Barand Posted October 27, 2015 Solution Share Posted October 27, 2015 if you run this query SELECT * FROM zamjene_brojeva WHERE glavni_broj='966 45 19-68' does it list those four records? 1 Quote Link to comment Share on other sites More sharing options...
benanamen Posted October 27, 2015 Share Posted October 27, 2015 You will get better quicker answers if you post an SQL dump of your DB. Quote Link to comment Share on other sites More sharing options...
budimir Posted October 28, 2015 Author Share Posted October 28, 2015 Guys, thanks for all you're help. I found a problem and it was on another script that was inserting data into that table. Something happened during the scheduled start and it didn't finish inserting all the records. Found the problem, fixed it and now I can get all the records I need. Once again, thanks for you're help. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.