For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
select * from employees e1
where 1=(select count(distinct(salary)) from employees e2 where e1.salary <= e2.salary);
Can anybody explain how does this query works?
how the count(distinct(salary)) is getting the rank?