Skip to content

Latest commit

 

History

History
74 lines (57 loc) · 1013 Bytes

READEME.md

File metadata and controls

74 lines (57 loc) · 1013 Bytes

Create SpredSheets


- クエリ調査
  SELECT 
      count(*)
  FROM 
      resumes
  WHERE 
      NOT EXISTS
      (
          SELECT 
              * 
          FROM 
              TableA AS a
          WHERE 
              job_id = ''

          UNION 

          SELECT 
              * 
          FROM 
              TableB ASas b
          WHERE 
              job_id = ''  
      );
    SELECT 
        count(*)
    FROM 
        resumes
    WHERE 
        NOT EXISTS
    (
    SELECT 
        * 
    FROM 
        TableA AS a
    WHERE 
        job_id = ''
    )
    OR
    NOT EXISTS
    (
    SELECT 
        * 
    FROM 
    TableB as b
    WHERE 
        job_id = ''  
    );