First Semester Exam Q6
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 |
|
November 15, 2011 01:04PM |
6.1
SELECT
E1.LAST_NAME Employee,
E1.HIRE_DATE EmployeeHired,
E2.LAST_NAME Manager,
E2.HIRE_DATE ManagerHired
FROM EMPLOYEES E1 JOIN EMPLOYEES E2
ON E1.MANAGER_ID = E2.EMPLOYEE_ID
WHERE E1.HIRE_DATE < E2.HIRE_DATE
6.2
SELECT
LAST_NAME Employee,
HIRE_DATE EmployeeHired
FROM EMPLOYEES
WHERE TO_NUMBER(TO_CHAR(HIRE_DATE,'fmDD'
) < 16
Any comments?
SELECT
E1.LAST_NAME Employee,
E1.HIRE_DATE EmployeeHired,
E2.LAST_NAME Manager,
E2.HIRE_DATE ManagerHired
FROM EMPLOYEES E1 JOIN EMPLOYEES E2
ON E1.MANAGER_ID = E2.EMPLOYEE_ID
WHERE E1.HIRE_DATE < E2.HIRE_DATE
6.2
SELECT
LAST_NAME Employee,
HIRE_DATE EmployeeHired
FROM EMPLOYEES
WHERE TO_NUMBER(TO_CHAR(HIRE_DATE,'fmDD'
) < 16
Any comments?
Sorry, only registered users may post in this forum.