Core Java

Core Java

Share

for learning purpose core Java

21/06/2023

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.

16/06/2023

new features in Core Java 1 page.

28/11/2022

Map Collection

Want your business to be the top-listed Computer & Electronics Service in Pune?
Click here to claim your Sponsored Listing.

Website

Address


Pune