Discussion board
If the value in the column is repeatable, how do you find out the unique values?
By Abhijit Paul
If the value in the column is repeatable, how do you find out the unique values?????
Reply
Post   Reset
Teacher SiliconIndia replied to Abhijit Paul Thursday, March 18, 2010
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;