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.

Why do you want to find duplicate values? Because perhaps you can write some PHP code to find duplicate values?

SELECT City ,count(*) FROM `Persons` group by City

yes as vibhadevit says

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.