query

Expand Post »

How to check the duplicate Columns in a table

Similar Threads

Removing Query Strings in ASP.NET
Sql Query in VB.NET
Double MySQL Query in PHP
Dynamic Query in JSP
MySQL nested query / joined query conversion help in MySQL

sushilchandu

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Jun 2008

Permalink

Jul 1st, 2008

Re: query

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

sreein1986

Reputation Points: 12

Solved Threads: 34

Posting Whiz

Offline

306 posts
since May 2008

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MySQL Forum Timeline: Stored procedure error

Next Thread in MySQL Forum Timeline: INSERT columns into rows

DaniWeb Message

Cancel Changes

User Name
Password