How to select unique values of a column from table?

Question

Let's say I have a table:

| id | Name |
| 01 | Bob  |
| 02 | Chad |
| 03 | Bob  |
| 04 | Tim  |
| 05 | Bob  |

And I need to get the names which are mentioned only once (in this case: Chad and Tim) What is the query? Thanks.

Possible duplicate of [How to select unique records by SQL](https://stackoverflow.com/questions/1641718/how-to-select-unique-records-by-sql) — Gholamali Irani, Nov 29 '17 at 15:35
@bummi This is different case. OP wants only records (value in column) that occurs only once. — Lukasz Szozda, Nov 29 '17 at 15:36
just add having count(Name)=1, no need to answer, just comments. — Gholamali Irani, Nov 29 '17 at 15:37

score 3 · Accepted Answer · answered Nov 29 '17 at 15:31

3

You could use:

SELECT Name
FROM table
GROUP BY Name
HAVING COUNT(*) = 1;

answered Nov 29 '17 at 15:31

Lukasz Szozda

apomene · Answer 2 · 2017-11-29T15:32:50.223

0

You can use HAVING clause, like:

SELECT NAME FROM table GROUP BY NAME HAVING COUNT(NAME) = 1

edited Nov 29 '17 at 15:32

answered Nov 29 '17 at 15:31

apomene

1

Why SELECT DISTINCT? The GROUP BY returns no duplicates. – jarlh Nov 29 '17 at 15:32
Correct it was typo – apomene Nov 29 '17 at 15:33

2 Answers2