Changes

J.Y.S

270 bytes added, 21:05, 19 October 2010

→‎1.

''Saad''

<pre>

SELECT employee_id,

SUBSTR(last_name ||' '|| first_name, 1, 25) "Full Name",

job_id,

TO_CHAR(hire_date,'fmMonth "First in the year" YYYY') "Start Date"

FROM employees

WHERE TO_CHAR(hire_date,'fmMON') IN ('MAY','NOV')

ORDER BY hire_date DESC

/

</pre>

''James''

1

edit