DaniWeb IT Discussion Community

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/index.php)

- MySQL (http://www.daniweb.com/forums/forum126.html)

- - query (http://www.daniweb.com/forums/thread132017.html)

sushilchandu

Jul 1st, 2008 2:45 am

query

How to check the duplicate Columns in a table

sreein1986

Jul 1st, 2008 3:27 am

Re: query

 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

All times are GMT -4. The time now is 10:14 pm.