<abbr id="oucam"><strong id="oucam"></strong></abbr>

<samp id="oucam"><source id="oucam"></source></samp>

<cite id="oucam"></cite>

單項(xiàng)選擇題

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

你可能感興趣的試題

單項(xiàng)選擇題

Which clause should you use to exclude group results?（）

A. WHERE
B. HAVING
C. RESTRICT
D. GROUP BY
E. ORDER BY

單項(xiàng)選擇題

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 Scott's 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'；；