Muhammad Abdul Qaium is a Database Engineer/Oracle Apex Developer/BI Developer (in Connecticut, USA) who is an Oracle Certified Cloud Architect Professional, OCI Autonomous DB specialist as well as Oracle Business Intelligence Foundation Suite 11g Certified Implementation Specialist with extensive expertise in Database design , PL/SQL, Oracle Apex, Microsoft SSIS, ETL, Power BI, Qlik Sense, BI Publisher, Jasper Report, OBIEE. Contact: qaiuminfo@gmail.com
Sunday, July 23, 2017
Select Second Height Value/ Salary from a Table
SELECT *
FROM (SELECT e.* ,ROW_NUMBER () OVER (ORDER BY salary DESC) rn
FROM employees e)
WHERE rn = 2;
No comments:
Post a Comment