|
#11. The EMPLOYEE tables has these columns: LAST_NAME VARCHAR2(35)
SALARY NUMBER(8,2)
COMMISSION_PCT NUMBER(5,2) You want to display the name and annual salary multiplied by the commission_pct for all employees. For records that have a NULL commission_pct, a zero must be displayed against the calculated column. Which SQL statement displays the desired results?
Show comments for this question (1)
Add comments
Link to this question
|
gen. 0.059
Forum
Master braindump