Open main menu
CDOT Wiki
β
Search
Changes
← Older edit
Newer edit →
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
Saadism
1
edit