Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT e.last_name AS apellido, e.hire_date AS contratacion
- FROM employees e
- WHERE (e.department_id = (SELECT department_id
- FROM employees
- WHERE last_name = '&nombre'))
- AND (e.last_name <> '&nombre')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement