Which clause would you use in a SELECT statement to lim

单项选择题

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

相关考题

单项选择题 Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) DEPARTMENT_ID NUMBER SALARY NUMBER What is the correct syntax for an inline view?（）

单项选择题 Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?（）

单项选择题 In which scenario would index be most useful?（）

1Z0-007