Changes

J.Y.S

36 bytes removed, 22:06, 19 October 2010

→‎3.

</pre>

''Saad ~~- THIS RESULT IS DIFFERENT FROM ^~~''

<pre>

SELECT last_name, salary, job_id, NVL(TO_CHAR(manager_id),'No Manager') Manager#,

WHERE (manager_id IS NULL

OR job_id LIKE 'MK%')

AND ( salary* (NVL(commission_pct,0) + ~~100~~1) + 1000 ) > 10000

ORDER BY salary DESC

/

1

edit