Open main menu
CDOT Wiki
β
Search
Changes
← Older edit
Newer edit →
J.Y.S
1 byte removed
,
21:16, 19 October 2010
→
4.
<pre>
SELECT SUBSTR(first_name||' '||last_name, 25) Employee, job_id,
LPAD(TO_CHAR(salary,'$
999
99
,999'), 12, '=') Salary, department_name
FROM employees e JOIN departments d
USING (department_id)
Saadism
1
edit