Open main menu
CDOT Wiki
β
Search
Changes
← Older edit
Newer edit →
J.Y.S
9 bytes added
,
21:58, 19 October 2010
→
4.
''James''
<pre>
select substr(first_name ||' '|| last_name) "Employee", job_id, to_char(salary, '$999,999
', 12, '=
') Salary, department_name
from employees e join departments d
on (e.department_id = d.department_id)
James.Shaw
1
edit