Question

Say you’re preparing a report for the management to identify employees who have shown consistently high performance. Write an Oracle SQL query to retrieve the names and performance ratings of employees with a rating of 5 in all their performance evaluations.

Answer 1

SELECT employee_name

FROM employees

WHERE rating = 5

GROUP BY employee_name

HAVING COUNT(*) = (SELECT COUNT(*) FROM employees);