Advisory Board interview question
write a query to find data which is not available in second table?
Interview Answer
Anonymous
6 Jun 2015
select * from emp where emp_id not in (select emp_id from attendence where att_date =(TO_DATE(.....)))
write a query to find data which is not available in second table?
Anonymous
select * from emp where emp_id not in (select emp_id from attendence where att_date =(TO_DATE(.....)))
Check out your Company Bowl for anonymous work chats.