Organizational Research By

Surprising Reserch Topic

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

Related Hot Questions

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