Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • How to get count of duplicate values from table in mysql?

    @babita.dhami
    Recommendations Offline Message

    • 0
    • 1
    • 0
    • 1
    • 0
    • 0
    • 0
    • 0
    • 607
    Comment on it

    Sometimes we need to check how many duplicate values a column has in MySQL table. We can do this by using "group by" and "having".

    Example: Suppose you have a table "user" with "fist_name" column from which you want to find all the records which have duplicate values in column "first_name" then you just need to write the below command

    select first_name, count(first_name) from user group by first_name having count(first_name) > 1;

    the above command will return all the records having duplicate first_name.

    Hope this will help you :)

    mysql duplicate find duplicate records database GROUP BY having
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: