[Solved] query SELECT COUNT only unique values [closed]

Use the keyword DISTINCT in your query. For example:

SELECT COUNT(DISTINCT(Username)) FROM vpss;