单项选择题
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?（）
A. An error is returned.
B. You are prompted to enter a new value.
C. A report is produced that matches the first report produced.
D. You are asked whether you want a new value or if you want to run the report based on the previous value. -
单项选择题
Examine the structure of the EMPLOYEES table: What is the correct syntax for an inline view?（）
A.
B.
C.
D.
-
多项选择题
In which four clauses can a subquery be used?（）
A. in the INTO clause of an INSERT statement
B. in the FROM clause of a SELECT statement
C. in the GROUP BY clause of a SELECT statement
D. in the WHERE clause of a SELECT statement
E. in the SET clause of an UPDATE statement
F. in the VALUES clause of an INSERT statement
