I just like to know whether an alternative way is there for the below Analytical function and that too should give better performance compared to the Analytical function.
SELECT last_name FROM
(SELECT last_name, ROW_NUMBER() OVER (partition by department_id ORDER BY last_name) R FROM employees)
WHERE R =1;