DBA > Job Interview Questions > MySQL and SQL

If the value in the column is repeatable, how do

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

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;

(Continued on next question...)

Other Job Interview Questions