Member Avatar for sushilchandu

How to check the duplicate Columns in a table

  • 2 Contributors
  • 1 Reply
  • 124 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by sreein1986
Member Avatar for sreein1986 
SELECT YourColumn, COUNT(*) TotalCount
FROM YourTable
GROUP BY YourColumn
HAVING COUNT(*) > 1
ORDER BY COUNT(*) DESC

check above code for duplicate colums in a table

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.