How to find the second highest salary from emp table ?

Answer : Select max(sal)…

How to find the second highest salary from emp table ?

Select max(sal) from table_name where sal<(select max(sal)from table_name)
Leave a Reply

Your email address will not be published.

You May Also Like