Changes

Jump to: navigation, search

J.Y.S

236 bytes added, 22:06, 19 October 2010
2.
''Saad''
<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 job_id IN ('IT_PROG','ST CLERK')
AND (salary BETWEEN 5000 AND 12000)
/
</pre>
''James''
1
edit

Navigation menu