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

The correct answer is D. WHERE SALARY > 5000. You need to use the WHERE clause to limit the display to those employees whose salary is greater then 5000. Incorrect Answers A: The ORDER BY clause will just sort data, but it will not limit them. B: You cannot use the GROUP BY clause with conditions. Oracle error will be…

Restricting and Sorting Data

Question

Options

AORDER BY SALARY > 5000
BGROUP BY SALARY > 5000
CHAVING SALARY > 5000
DWHERE SALARY > 5000

How the community answered

(22 responses)

A
9% (2)
B
5% (1)
D
86% (19)

Explanation

You need to use the WHERE clause to limit the display to those employees whose salary is greater then 5000. Incorrect Answers A: The ORDER BY clause will just sort data, but it will not limit them. B: You cannot use the GROUP BY clause with conditions. Oracle error will be generated. C: The HAVING clause may be used only in conjunction with the GROUP BY clause.

Topics

#WHERE clause#comparison operators#row filtering#SELECT syntax

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice