I would like to count the number of rows from a mysql table and not to include duplicate entries,
Could I use distinct with count()?
distinct
count()
Sure.
SELECT COUNT(DISTINCT column) FROM table;
2.1m questions
2.1m answers
60 comments
57.0k users