Normally this question is asked check the analytical skills . This is the most commonly asked question the interviews.
select * from( select ename, sal, dense_rank() over(order by sal desc)r from Employee) where r=3;
A blog on SQL , PLSQL , Linux concepts. Interview Questions from different companies. For suggestions and contributions, reach me at sivak36@gmail.com
So Someone asked me a question, Will the data from Oracle Database be lost after formatting the system in which it is installed? Since the ...