Pregunta de entrevista de Aspiring Minds

Given a database of employees having entries for the bonus given to a particular employee for a particular month.You had to find the first 50 who didnt receive bonus in july.

Respuesta de la entrevista

Anónimo

18 sep 2015

Interviewer wants to access your knowledge of joins. Query should be SELECT * from employees LEFT JOIN salary ON employees.emp_id=salary.emp_id

7