Count number of unique values

by

use

SELECT count( DISTINCT(email) ) FROM orders

Distinct provide unique email ids and then simply count them.

More Related Contents:

  1. Error related to only_full_group_by when executing a query in MySql
  2. Find duplicate records in MySQL
  3. How to declare a variable in MySQL?
  4. Can you split/explode a field in a MySQL query?
  5. MySQL order by before group by
  6. MySQL Cannot Add Foreign Key Constraint
  7. Which is fastest? SELECT SQL_CALC_FOUND_ROWS FROM `table`, or SELECT COUNT(*)
  8. Grouping into interval of 5 minutes within a time range
  9. ERROR 1044 (42000): Access denied for user ”@’localhost’ to database ‘db’
  10. Difference between float and decimal data type
  11. Convert timestamp to date in MySQL query
  12. Update a column value, replacing part of a string
  13. Parse date in MySQL
  14. mysql dynamic query in stored procedure
  15. mysql: get record count between two date-time
  16. Difference between these two joining table approaches?
  17. MySQL INT meaning
  18. Get total number of rows when using LIMIT? [duplicate]
  19. Table is specified twice, both as a target for ‘UPDATE’ and as a separate source for data in mysql
  20. MySQL export into outfile : CSV escaping chars
  21. Simple Random Samples from a MySQL Sql database
  22. MySQL LAST_INSERT_ID() used with multiple records INSERT statement
  23. MySQL Select minimum/maximum among two (or more) given values
  24. MySQL: Many tables or many databases?
  25. Select only last value using group by at mysql
  26. MySQL errorno 121
  27. How can I “select *” from a table in MySQL but omit certain columns?
  28. For homebrew mysql installs, where’s my.cnf?
  29. Force MySQL to return duplicates from WHERE IN clause without using JOIN/UNION?
  30. comparison of truncate vs delete in mysql/sqlserver [duplicate]

Leave a Comment