If the value in the column is repeatable, how do you find out the unique values?
Use DISTINCT in the query, such as
SELECT DISTINCT user_firstname FROM users; You can also ask for a number of
distinct values by saying SELECT COUNT (DISTINCT user_firstname) FROM users;
No comments:
Post a Comment