移动端

  • 题王微信公众号

    题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

单选题

Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) Which statement produces the number of different departments that have employees with last name Smith?()

发布日期:2020-04-10

Examine the description of the EMPLOYEES table: EM...
A

SELECT COUNT (*) FROM employees WHERE last _name='smith';

B

SELECT COUNT (dept_id) FROM employees WHERE last _name='smith';

C

SELECT DISTINCT (COUNT (dept_id) FROM employees WHERE last _name='smith';

D

SELECT COUNT (DISTINCT dept_id) FROM employees WHERE last _name='smith';

E

SELECT UNIQE (dept_id) FROM employees WHERE last _name='smith';

题王网让考试变得更简单

扫码关注题王,更多免费功能准备上线!

此试题出现在

CMS专题

CMS专题

去刷题
热门试题热门资讯 相关试题

暂无相关推荐~