Core Java

Hi all,
Use below to get highest salary of employee like 1st ,2nd ,5th ---- nth (oracle database).

Type 1:
=====
SELECT MAX(SAL) FROM EMP;

Type 2:
=====
SELECT SAL FROM (SELECT SAL, RANK() OVER ( ORDER BY SAL DESC) AS RANK FROM EMP ) T WHERE RANK=5;

In place of 5 you can passed any number based on requirement.

new features in Core Java 1 page.

Map Collection