SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table t1(id int, name varchar(10))
insert into t1 values(1,'Bob'),(2,'Chad'),(3,'Bob'),(4,'Tim'),(5,'Bob')
5 rows affected

select * from t1 a
where not exists (select 1 from t1 b where a.name=b.name having count(*)>1)


id
name


2
Chad

4
Tim


| id | Name |
| 01 | Bob  |
| 02 | Chad |
| 03 | Bob  |
| 04 | Tim  |
| 05 | Bob  |
Msg 102 Level 15 State 1 Line 1
Incorrect syntax near '|'.