rank() oracle
--DROP TABLE BUILDING_MANAGER; CREATE TABLE BUILDING_MANAGER (BUILDING_NO1 VARCHAR2(3) NOT NULL ENABLE, BUILDING_NO2 VARCHAR2(5) NOT NULL ENABLE, MANAGER_NAME VARCHAR2(30) NOT NULL ENABLE, SAFE_APPOINT_DE VARCHAR2(8) NOT NULL ENABLE, SAFE_LICENSE_NO VARCHAR2(30), REGIST_DT DATE NOT NULL ENABLE, CONSTRAINT PK_BULDING_MANAGER PRIMARY KEY (BUILDING_NO1, BUILDING_NO2, SAFE_LICENSE_NO) ); INSERT INTO BUILDING_MANAGER(BUILDING_NO1 ,BUILDING_NO2 ,MANAGER_NAME ,SAFE_APPOINT_DE ,SAFE_LICENSE_NO ,REGIST_DT) VALUES('100','200','lisa','20150923','00100123F',sysdate); INSERT INTO BUILDING_MANAGER(BUILDING_NO1 ,BUILDING_NO2 ,MANAGER_NAME ,SAFE_APPOINT_DE ,SAFE_LICENSE_NO ,REGIST_DT) VALUES('100','875','tyra','20150722','00109921I',sysdate); INSERT INTO BUILDING_MANAGER(BUILDING_NO1 ,BUILDING_NO2 ,MANAGER_NAME ,SAFE_APPOINT_DE ,SAFE_LICENSE_NO ,REGIST_DT) VALUES('315','123','emma'...