Changes

Jump to: navigation, search

J.Y.S

No change in size, 00:04, 20 October 2010
8.
''James''
<pre>
select department_id, department_name, substr(nvl(city,'Not Assigned Yet'),1,25) City, count(DISTINCT distinct job_id) '"# of Jobs'"from employeesright outer join departments
using (department_id)
left outer join locations
1
edit

Navigation menu