Welcome!
Log In
Create A New Profile
Home
>
2011
>
INF307H
> Topic
Advanced
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
Forums
Messages
New
Darkling
First Semester Exam Q6
November 15, 2011 01:04PM
Registered: 15 years ago
Posts: 234
Rating: 0
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?
Reply
Quote
Newer Topic
Older Topic
Print View
RSS
Sorry, only registered users may post in this forum.
Click here to login