Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater then 5000? ()A. ORDER BY SALARY > 5000B. GROUP BY SALARY > 5000C. HAVING SALARY > 5000D. WHERE SALARY > 5000

题目
Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater then 5000? ()

A. ORDER BY SALARY > 5000

B. GROUP BY SALARY > 5000

C. HAVING SALARY > 5000

D. WHERE SALARY > 5000

相似考题

1.EMPLOYEES中职员编号为90的职员的commission_pct为空值,salary为1000,语句select12*salary*(commission_pct＋0.2)comm from EMPLOYEES;comm显示的结果是()。A.12000B.0C.2400D.NULL

2.7． If I _______ you，l_______ take an umbrella with me．A． was ; shouldB． was ; wouldC． were ; willD． were ; would

3.If you don’t like to swim, you _____as well stay at home.A)should B)may C)can D)would

4.”You ____ have a wrong number,” she said. “There’s no one of that name here.”A. needB. canC. mustD. would

更多“Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater then 5000? () ”相关问题

  • 第1题：

    "You _________ finish your homework before the dinner." said mother.

    A.should

    B.have to

    C.must

    D.would


    参考答案：C

  • 第2题：

    Examine the data in the EMPLOYEES table:LAST_NAME DEPARTMENT_ID SALARYGetz 10 3000Davis 20 1500Bill 20 2200Davis 30 5000...Which three subqueries work? ()

    A. SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department _ id);

    B. SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);

    C. SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);

    D. SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);

    E. SELECT last_name FROM employees Where salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);

    F. SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));


    参考答案：C, D, E

  • 第3题：

    有如下语句：

    OPEN DATABASE学生管理 SELECT 1

    USE学生SELECT 2 USE课程 SELECT 3 USE成绩 如果要到第1个工作区去操作学生表，则命令是（ ）。

    A. SELECT O

    B. SELECT 1

    C. SELECT 2

    D. SELECT 3


    正确答案：B
    本题考查多工作区的概念，程序分别在第1、2、3个工作区打开了学生、课程和成绩3个表，如果要到第1个工作区操作学生表，可用命令SELECT学生或SELECT1。

  • 第4题：

    Examine the data in the EMPLOYEES table:Which three subqueries work? ()

    A. SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department _ id);

    B. SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);

    C. SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);

    D. SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);

    E. SELECT last_name FROM employees Where salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);

    F. SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));


    参考答案：C, D, E

  • 第5题：

    Click the Exhibit button and examine the data in the EMPLOYEES table.Which three subqueries work? ()

    A.SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department_id);

    B.SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id);

    C.SELECT distinct department_id FROM employees WHERE salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id);

    D.SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id);

    E.SELECT last_name FROM employees WHERE salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department_id);

    F.SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY));


    参考答案：C, D, E

  • 第6题：

    “You ____ have a wrong number,” she said. “There’s no one of that name here.”

    A. need

    B. can

    C. must

    D. would


    正确答案：C
    解析：must have意思是肯定有什么，依题意可得，答案是C。

相关内容