Welcome! Log In Create A New Profile

First Semester Exam Q7

Posted by Darkling

Announcements		Last Post
	SoC Curricula	09/30/2017 01:08PM
	Demarcation or scoping of examinations and assessment	02/13/2017 07:59AM
	School of Computing Short Learning Programmes	11/24/2014 08:37AM
	Unisa contact information	07/28/2011 01:28PM

Forums Messages New

Darkling

First Semester Exam Q7
November 15, 2011 01:22PM

Registered: 15 years ago
Posts: 234
Rating: 0

SELECT
EMPLOYEE_ID ID,
LAST_NAME Employee

FROM EMPLOYEES
WHERE Department_ID IN (SELECT Department_ID FROM DEPARTMENTS)
AND LAST_NAME LIKE '%u%'

Any Comments?

Reply Quote

Jaxy

Re: First Semester Exam Q7
November 15, 2011 03:04PM

Registered: 14 years ago
Posts: 38
Rating: 0

practise 6...

SELECT employee_id, last_name
FROM employees
WHERE department_id IN (SELECT department_id
FROM employees
WHERE last_name like '%u%' winking smiley