Using DISTINCT and COUNT together in a MySQL Query

by

use 

SELECT COUNT(DISTINCT productId) from  table_name WHERE keyword='$keyword'

More Related Contents:

  1. INSERT INTO SELECT statement with more columns which is not in another table
  2. MySQL how to fill missing dates in range?
  3. Left Outer Join doesn’t return all rows from my left table?
  4. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  5. 1052: Column ‘id’ in field list is ambiguous
  6. How to split the name string in mysql?
  7. Can a foreign key reference a non-unique index?
  8. Why does MySQL allow “group by” queries WITHOUT aggregate functions?
  9. Cumulative sum over a set of rows in mysql
  10. How to set a maximum execution time for a mysql query?
  11. Set NOW() as Default Value for datetime datatype?
  12. SQL keys, MUL vs PRI vs UNI
  13. Add Auto-Increment ID to existing table?
  14. MySQL SELECT DISTINCT multiple columns
  15. How to copy a row and insert in same table with a autoincrement field in MySQL?
  16. SQL DELETE with JOIN another table for WHERE condition
  17. How to change the default port of mysql from 3306 to 3360
  18. How to move columns in a MySQL table?
  19. Using group by on two fields and count in SQL
  20. Can MySQL convert a stored UTC time to local timezone?
  21. Whats the fastest way to lookup big tables for points within radius MySQL (latitude longitude)
  22. quick selection of a random row from a large table in mysql
  23. How can we find gaps in sequential numbering in MySQL?
  24. MySQL CONCAT returns NULL if any field contain NULL
  25. Does Order of Fields of Multi-Column Index in MySQL Matter
  26. Alternative to using LIMIT keyword in a SubQuery in MYSQL
  27. How to check if field is null or empty in MySQL?
  28. mysql select id and name from other table and join query
  29. Convert SQL Server query to MySQL [duplicate]
  30. comparison of truncate vs delete in mysql/sqlserver [duplicate]

Leave a Comment