Select Code to Download

select record_id
  from lookup
 where name = 'JOHN'

NAME   RECORD_ID
----   ---------
...
DEER    3
JOHN    4
DOE     4

select record_id
  from lookup
 where name in ('JOHN', 'SMITH')
 group by record_id