Difference between revisions of "J.Y.S"
Yujin.jeong (talk | contribs) |
Yujin.jeong (talk | contribs) (→Solution: uploaded solution for quesiton 1) |
||
| Line 30: | Line 30: | ||
1. | 1. | ||
<pre> | <pre> | ||
| − | SELECT | + | SELECT employee_id, RPAD(CONCAT(CONCAT(last_name, ', '),first_name), 25) "Full Name", job_id, |
| + | TO_CHAR(TRUNC(hire_date, 'MONTH'), 'fmMonth Ddspth "in the year" YYYY') "Start Date" | ||
| + | FROM employees | ||
| + | WHERE TO_CHAR(hire_date, 'Mon') IN ('May', 'Nov') | ||
| + | ORDER BY hire_date DESC; | ||
</pre> | </pre> | ||
2. | 2. | ||
Revision as of 12:44, 5 October 2010
This page is to efficiently manage DBS301 Group assignments together !
Member List
| First Name | Last Name | wiki id | Learn e-mail | Phone |
|---|---|---|---|---|
| YuJin | Jeong | yujin.jeong | yjeong | 647 - 832 - 6771 |
| Saad | ||||
| James | ||||
| Dale |
Assignment 1
Due Date
Thursday, October 21st, 4:00pm Printout submission only( SELECT Statements + ALL outputs)
Description
Solution
1.
SELECT employee_id, RPAD(CONCAT(CONCAT(last_name, ', '),first_name), 25) "Full Name", job_id,
TO_CHAR(TRUNC(hire_date, 'MONTH'), 'fmMonth Ddspth "in the year" YYYY') "Start Date"
FROM employees
WHERE TO_CHAR(hire_date, 'Mon') IN ('May', 'Nov')
ORDER BY hire_date DESC;
2. 3. 4. 5. 6.
