InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
If The Value In The Column Is Repeatable, How Do You Find Out The Unique Values? |
|
Answer» 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; 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; |
|