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;
1.4m articles
1.4m replys
5 comments
57.0k users