display Nth highest salary.


SELECT   e1.sal
FROM employee e1
WHERE &N = (SELECT COUNT(DISTINCT (sal) )
            FROM employee e2

            WHERE e1.sal <= e2.sal);

Comments

Post a Comment

Popular posts from this blog

ETL TOOLS

List of the most popular ETL tools:   Informatica - Power Center IBM - Websphere DataStage(Formerly known as Ascential  DataStage ) SAP - BusinessObjects  Data Integrator IBM - Cognos Data Manager (Formerly known as Cognos DecisionStream) Microsoft -  SQL Server  Integration Services Oracle - Data Integrator (Formerly known as Sunopsis Data Conductor) SAS - Data  Integration Studio Oracle - Warehouse Builder AB Initio Information Builders  - Data Migrator Pentaho - Pentaho Data Integration Embarcadero Technologies - DT/Studio IKAN - ETL4ALL IBM - DB2 Warehouse Edition Pervasive - Data Integrator ETL Solutions Ltd. - Transformation Manager Group 1 Software (Sagent) - DataFlow Sybase - Data Integrated Suite ETL Talend - Talend Open Studio Expressor Software - Expressor Semantic Data Integration System Elixir - Elixir Repertoire OpenSys – CloverETL
Read more

RANK FUNCTION

SIMPLE RANK FUNCTION: CREATE TABLE STUDENT   (     S_ID        NUMBER(10),     S_NAME      VARCHAR(30),     TAMIL_MARKS NUMBER(10),     ENGLISH_MARKS NUMBER(10),     MATHS_MARKS NUMBER(10),     SCIENCE_MARKS NUMBER(10),     S_SCIENCE_MARKS NUMBER(10)   );      INSERT INTO STUDENT VALUES(1,'PANDIAN',35,45,55,65,75);   INSERT INTO STUDENT VALUES(2,'MUTHU',37,47,57,67,77);   INSERT INTO STUDENT VALUES(3,'ASHOK',40,50,60,70,80);      INSERT INTO STUDENT VALUES(4,'KUMAR',33,43,53,63,73);   INSERT INTO STUDENT VALUES(5,'RANA',36,46,56,66,76);         SELECT * FROM STUDENT; 1 PANDIAN 35 45 55 65 75 2 MUTHU 37 47 57 67 77 3 ASHOK 40 50 60 70 80 4 KUMAR 33 43 53 63 73 5 RANA 36 46 56 66 76  SELECT S_NAME,TOTAL,R...
Read more