Welcome! Log In Create A New Profile

First Semester Exam Q3

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 Q3
November 15, 2011 11:30AM

Registered: 15 years ago
Posts: 234
Rating: 0

3.1
SELECT
E.LAST_NAME Employee,
J.JOB_TITLE Job,
E.SALARY sal

FROM EMPLOYEES E JOIN JOBS J ON E.JOB_ID = J.JOB_ID
WHERE

J.JOB_TITLE = 'Sales Representative'
OR
J.JOB_TITLE = 'Stock Clerk'

AND
E.SALARY NOT IN (2500,3500,7000)

3.2
SELECT DISTINCT DEPARTMENT_ID, JOB_ID FROM EMPLOYEES
WHERE DEPARTMENT_ID IN (10,20)
ORDER BY DEPARTMENT_ID ASC

Any Comments?

Reply Quote

Jaxy

Re: First Semester Exam Q3
November 15, 2011 02:58PM

Registered: 14 years ago
Posts: 38
Rating: 0

I didn't do a join for this one.

Select last_name, salary,job_id
from employees
where job_id like '%SA_R%' or job_id like '%ST_CL%'
and salary not in (2500,3500,7000)

This one can be found in practise 2