MySQL

query

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Jun 2008

Posts: 4

Reputation: sushilchandu is an unknown quantity at this point

Solved Threads: 0

sushilchandu sushilchandu is offline

Offline

Newbie Poster

query

Jul 1st, 2008

How to check the duplicate Columns in a table

Thanks & Regards
Sushil Kumar Chandu

•

Join Date: May 2008

Posts: 302

Reputation: sreein1986 is an unknown quantity at this point

Solved Threads: 33

sreein1986 sreein1986 is offline

Offline

Posting Whiz

Re: query

Jul 1st, 2008

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
 SELECT YourColumn, COUNT(*) TotalCount
FROM YourTable
GROUP BY YourColumn
HAVING COUNT(*) > 1
ORDER BY COUNT(*) DESC
 SELECT YourColumn, COUNT(*) TotalCount
FROM YourTable
GROUP BY YourColumn
HAVING COUNT(*) > 1
ORDER BY COUNT(*) DESC