Forum : If the value in the column is repeatable, how do you find out the unique values?
Brief description about Online courses   join in Online courses
Home News Viewpoint
Travel Entertainment Auto Gadgets & Electronics Sports Lifestyle Food
Rankings Whitepapers Blogs Conferences About Us
View Abhijit Paul 's Profile

If the value in the column is repeatable, how do you find out the unique values?

If the value in the column is repeatable, how do you find out the unique values?????
Asked by Abhijit Paul | Mar 18, 2010 |  Reply now
Replies (1)
View teacher siliconindia 's Profile
Hi Abhijit,
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;
Mar 18, 2010

Forum By Category