单项选择题
The EMPLOYEES table contains these columns:
LAST_NAME VARCHAR2 (25)
SALARY NUMBER (6,2)
COMMISSION_PCT NUMBER (6)
You need to write a query that will produce these results:
1. Display the salary multiplied by the commission_pct.
2. Exclude employees with a zero commission_pct.
3. Display a zero for employees with a null commission value.
Evaluate the SQL statement:
SELECT LAST_NAME, SALARY*COMMISSION_PCT
FROM EMPLOYEES
WHERE COMMISSION_PCT IS NOT NULL;
What does the statement provide?（）
A.All of the desired results
B.Two of the desired results
C.One of the desired results
D.An error statement
相关考题
-
单项选择题
A subquery can be used to （）.
A. Create groups of data
B. Sort data in a specific order
C. Convert data to a different format
D. Retrieve data based on an unknown condition -
单项选择题
Which clause should you use to exclude group results?（）
A. WHERE
B. HAVING
C. RESTRICT
D. GROUP BY
E. ORDER BY -
单项选择题
Scott issues the SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)}; GRANT SELECT ON DEPT T0 SUE; If Sue needs to select from Scotts DEPT table, which command should she use?（）
A.SELECT*FROMDEPT；
B.SELECT*FROMSCOTT.DEPT；
C.SELECT*FROMDBASCOTTDEPT；
D.SELECT*FROMALL_USERSWHEREUSER_NAME='；SCOTT'；ANDTABLENAME='；DEPT'；；
