Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • How to count unique values from table in mysql?

    • 0
    • 1
    • 0
    • 1
    • 0
    • 0
    • 0
    • 0
    • 361
    Comment on it

    Sometimes we have the requirement to count how many unique values are in the table. We can do this by using "Distinct" and count().

    SELECT COUNT(DISTINCT column_name) FROM table_name;
    

    Example: Suppose you have a table user from which you want to count how many unique emails are in the table. You can do this by using the below command

    select count(distinct email_id) from user;
    

    in the above command Distinct will provide unique email ids and then will count them.

    Hope this will help you :)

 0 Comment(s)

Sign In
                           OR                           
                           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: