Monday, 27 August 2012

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

A. ORDER BY SALARY > 5000
B. GROUP BY SALARY > 5000
C. HAVING SALARY > 5000
D. WHERE SALARY > 5000

Ans:D

No comments: