Follow the following Query, You get the second highest
SQL> Select level,Max(sal) from emp
Where level=&level connect by prior sal>sal
group by level;
SQL> Enter the level No=2 (Here enter 2 manually)
Then you will get the 2nd highest salary.
If you want 3rd Highest salary, then enter level no=3.
city name country code
write a procedure , so that when we give a phone no. eg -
o/p sud be city name = abc
if phone no. - 2322345897 , o/p sud be =cde
note - bcd and cde city name sud be diff. as dey diff only
with th last no.
Pls ans. this questnion.
one of the column in my table contains the data like
So my requirement is i want output like
it mean i want to delete duplicate rows in the table
permanently and i want output in the above formatow should u