How to find the unique values if the value in the column is repeated?

asked Sep 13, 2013 in MYSQL by rajesh
edited Sep 12, 2013
0 votes

1 Answer

0 votes

If the values in the column of a table are repeating and a unique value has to be found then the following command can be used in the query:

SELECT DISTINCT user_firstname FROM users; 
There is another command which can be used to find the command to see the distinct values as:
SELECT COUNT (DISTINCT user_firstname) FROM users;
answered Sep 13, 2013 by rajesh
edited Sep 12, 2013