query
Please support our MySQL advertiser: Programming Forums
Thread Solved
 |
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,
Sreekanth
http://shiriyal.blogspot.com/
if you problem solved add me as a reputation and mark it mark as solved
Sreekanth
http://shiriyal.blogspot.com/
if you problem solved add me as a reputation and mark it mark as solved
|
Similar Threads
Other Threads in the MySQL Forum
- Sql Query (VB.NET)
- Removing Query Strings (ASP.NET)
- Double MySQL Query (PHP)
- Dynamic Query (JSP)
- MySQL nested query / joined query conversion help (MySQL)
- problem with lengthy query (Java)
- Retreiving variables from a sql query into a form (PHP)
- Query Building (Database Design)
Other Threads in the MySQL Forum
- Previous Thread: Stored procedure error
- Next Thread: INSERT columns into rows
•
•
•
•
Views: 581 | Replies: 1 | Currently Viewing: 1 (0 members and 1 guests)
Linear Mode
