Member Avatar for jacob21

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.

  • 5 Contributors
  • 4 Replies
  • 100 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by metalix
Member Avatar for minitauros

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

Member Avatar for vibhaJ 
SELECT City ,count(*) FROM `Persons` group by City
Member Avatar for Yemen Coder

yes as vibhadevit says

Member Avatar for metalix

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.