Question

Write an Oracle SQL query to find the five most common names in the Employee table.

Answer 1

SELECT name, COUNT(*) AS name_count

FROM Employee

GROUP BY name

ORDER BY name_count DESC

FETCH FIRST 5 ROWS ONLY;