Pergunta de entrevista da empresa Advisory Board

write a query to find data which is not available in second table?

Resposta da entrevista

Sigiloso

6 de jun. de 2015

select * from emp where emp_id not in (select emp_id from attendence where att_date =(TO_DATE(.....)))