Open main menu

CDOT Wiki β

Changes

J.Y.S

21 bytes added, 15:25, 20 October 2010
2.
<pre>
SELECT 'Employee named ' || first_name || ' ' || last_name || ' who is '
|| job_id || ' will have a new salary of $' || TO_CHAR(salary * 1.15 , 'fm$999999') "Happy Employees"
FROM employees
WHERE salary BETWEEN 5000 AND 12000