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 this statement: SELECT student_id, gpa FROM student_grades WHERE gpa >&&value; You run the statement once, and when prompted you enter a value of 2.0. A report is produced. What happens when you run the statement a second time?（）

单项选择题 Examine the structure of the EMPLOYEES table: What is the correct syntax for an inline view?（）

多项选择题 In which four clauses can a subquery be used?（）

1Z0-007