Help for this page

Select Code to Download


  1. or download this
    select record_id
      from lookup
     where name = 'JOHN'
    
  2. or download this
    NAME   RECORD_ID
    ----   ---------
    ...
    DEER    3
    JOHN    4
    DOE     4
    
  3. or download this
    select record_id
      from lookup
     where name in ('JOHN', 'SMITH')
     group by record_id