Changes

J.Y.S

15 bytes added, 21:55, 19 October 2010

→‎4.

LPAD(TO_CHAR(salary,'$99,999'), 12, '=') Salary, department_name

FROM employees e JOIN departments d

~~USING~~ ON (d.department_id=e.department_id)

WHERE salary < (SELECT MAX(salary)

FROM employees

1

edit