Friday, 13 December 2013

To show the top 4 employees salary information from emp table

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;



No comments:

Post a Comment

Script to update salespersons customer site wise in oracle apps R12

SELECT * FROM HZ_PARTIES WHERE PARTY_NAME LIKE 'DEENA VISION%'; SELECT * FROM HZ_CUST_ACCOUNTS_ALL WHERE PARTY_ID =94043 ; SE...