To find out highest salary of Three Persons in Organization(N th) for Oracle SQL Query :
or We want fin out Top 2 highest salary in company :
Example Query : To show the top 4 employees salary information from emp table
SELECT ENAME, EMPNO,SAL FROM (SELECT ENAME,EMPNO,SAL FROM EMP ORDER BY SAL DESC) WHERE ROWNUM <5;
or We want fin out Top 2 highest salary in company :
Example Query : To show the top 4 employees salary information from emp table
SELECT ENAME, EMPNO,SAL FROM (SELECT ENAME,EMPNO,SAL FROM EMP ORDER BY SAL DESC) WHERE ROWNUM <5;
No comments:
Post a Comment