Welcome!
Log In
Create A New Profile
Home
>
2011
>
INF307H
> Topic
Advanced
First Semester Exam Q4
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 Q4
November 15, 2011 12:00PM
Registered: 15 years ago
Posts: 234
Rating: 0
4.1
SELECT
LAST_NAME Employee,
ROUND(MONTHS_BETWEEN(SYSDATE,HIRE_DATE)) MONTHS_WORKED
FROM EMPLOYEES
ORDER BY MONTHS_WORKED ASC
4.2
SELECT
LAST_NAME Employee,
DECODE(NVL(COMMISSION_PCT,0), 0, 'No', 'Yes'
Commision
FROM EMPLOYEES
Any Comments?
Reply
Quote
Jaxy
Re: First Semester Exam Q4
November 15, 2011 03:00PM
Registered: 14 years ago
Posts: 38
Rating: 0
spot on......
Reply
Quote
Newer Topic
Older Topic
Print View
RSS
Sorry, only registered users may post in this forum.
Click here to login