Changes

J.Y.S

294 bytes added, 21:21, 19 October 2010

→‎1.

''James''

<pre>

select employee_id "Emp#",

(last_name ||', '|| first_name) "Full Name",

job_id "Job",

to_char(trunc(hire_date, 'MONTH'), 'FMMonth Ddspth "in the year"

YYYY') "Start Date"

from employees

where to_char(hire_date, 'fmMonth') in ('May', 'November')

order by hire_date desc;

</pre>

1

edit