SELECT DISTINCT City FROM Persons
this query is for finding distinct(different) value.
how to find duplicate values which are not find by Distinct query.i.e repetitive(duplicate) values.
jacob21
0
Posting Whiz in Training
Recommended Answers
Jump to PostWhy do you want to find duplicate values? Because perhaps you can write some PHP code to find duplicate values?
All 4 Replies
minitauros
151
Junior Poster
Featured Poster
Why do you want to find duplicate values? Because perhaps you can write some PHP code to find duplicate values?
vibhaJ
126
Master Poster
SELECT City ,count(*) FROM `Persons` group by City
Yemen Coder
1
Newbie Poster
yes as vibhadevit says
metalix
0
Posting Whiz in Training
To find only the duplicates you should get the entire table, and use the mysql php code to just remove all that don't hit count 2+ (no doubles)
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.