Advertisement
Guest User

Untitled

a guest
May 23rd, 2017
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  
  2.  
  3. SELECT e.last_name AS apellido, e.hire_date AS contratacion
  4. FROM employees e
  5. WHERE (e.department_id = (SELECT department_id
  6.                          FROM employees
  7.                          WHERE last_name = '&nombre'))
  8. AND (e.last_name <> '&nombre')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement