We can used dens_rank() function to find the rank of salaries of employees and then put in a subquery to get rank is equal to 3.
select * from( select ename, sal, dense_rank() over(order by sal desc)r from Employee) where r=3;
Subscribe to:
Post Comments (Atom)
-
How to close Axis bank account: First take out all the money of your account, withdraw it, Visit nearest AXIS BANK branch with yo...
-
Combine files using Notepad++ : There is a plug-in available at http://www.scout-soft.com/combine/ to install for Notepad++. Download:... -
How Do I Flush My Windows DNS Cache? The following guide will walk you through clearing your DNS Cache. Every time you venture onto t...
No comments:
Post a Comment