SQL> create table table1 (name varchar2(20), city varchar2(20));

Table created.

SQL> insert all
  2  into table1 values ('Blazix','Atlanta')
  3  into table1 values ('Derrick','New Jersey')
  4  into table1 values ('Blazix','New York')
  5  select * from dual;

3 rows created.

SQL> SELECT name FROM table1
  2  MINUS
  3  SELECT name FROM table1
  4  WHERE  city = 'Atlanta';

NAME
------------------------------
Derrick

1 row selected.

SQL> SELECT name FROM table1 t1
  2  WHERE  NOT EXISTS
  3         ( SELECT 1 FROM table1
  4           WHERE  name = t1.name
  5           AND    city = 'Atlanta' )
  6

NAME
------------------------------
Derrick

1 row selected.