Changes

Jump to: navigation, search

J.Y.S

268 bytes added, 21:23, 19 October 2010
2.
''James''
<pre>
Select ('Employee named ' || first_name ||' '|| last_name || ' who is ' || job_id || ' will have a new salary of ' || (salary*1.15)) "Happy Employees"
From employees
Where salary between 5000 and 12000
And upper(job_id) in ('IT_PROG', 'ST_CLERK')
order by employee_id
</pre>
1
edit

Navigation menu