Dear All,
I can get min salary using rownum but can’t find min name using rownum, i am using same senorio in my environment please help me.
For example:
select min(salary) from employees where rownum<=2 order by salary desc
select min(last_name) from employees where rownum<=2 order by last_name desc