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;
My view and review on different things. All in one blog from the perspective of me (The Author) from technology , society , people, process, rights, many other things.
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;
For any one to build wealth , one must be disciplined in and have consistency in their actions. Most people start few things and after few days they lose momentum, stop focusing on what they started. Forming a habit is important which puts you in auto pilot mode.
To save money :
Take a decision to save at least 40 % of monthly earning.
Cut your unnecessary expenses
Delay big ticket desire until you have a decent wealth is built
Buy only what is needed
Stay way from debt and paying interest until you built wealth
Do not lend your saved money to your friends , family unless is really required. Money makes people bad.
Start putting your saved money into debt funds until your decent amount of funds are built.
Once a decent amount of funds are available , buy some good /valuable equities, real estate, gold etc.
Do not swap your funds too money times, let the compounding power take place.
Be patient so that your money multiplies
Risk management is key to everybody's life.
In that aspect, an earning person of a family must have a term life insurance. Most of the insurance companies try to sell money back or investment related insurance plans. But one but be aware that , we should not mix investments with Insurance. Insurance is purely for the risk management in life. The returns associated with insurance products wont beat the inflation or the long-term market returns.
His/Her entire family must have health insurance. Even if the person has company sponsored health insurance, the person must take their own health insurance, so that when in job loss or not working anymore, the person can have the health insurance covering the emergency medical expenses.
Every individual should opt for term life insurance, health insurance.
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 * ...