Changes

J.Y.S

4 bytes added, 23:02, 19 October 2010

→‎3.

</pre>

''Saad - THIS ~~ANSWER~~ 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~~+1000~~ * (NVL(commission_pct,0) + 100)+ 1000 ) > 10000

ORDER BY salary DESC

/

</pre>

''James''

1

edit