Select within select

[prashanth.n]

Is there a way to write select statement within select statement?

Yes, we can write Select statement within select statement.
For instance, To get 2nd max sal we can use below query.
Select max(sal) from emp where sal < (select max(sal) from emp).