DaniWeb IT Discussion Community - View Single Post

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

check above code for duplicate colums in a table

Thanx,
Shiriyal
http://shiriyal.blogspot.com/
if you problem solved add me as a reputation and mark it mark as solved