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? （）

备案号：湘ICP备14005140号-5

经营许可证号：湘B2-20140064

1Z0-007