Open main menu

CDOT Wiki β

Changes

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)
1
edit