SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE CASHBACK_PERIOD ( "ID" NUMBER, "CARD_NUMBER" VARCHAR2(16), "OPEN_CASHBACK" TIMESTAMP (6), "CLOSE_CASHBACK" TIMESTAMP (6) ); insert into CASHBACK_PERIOD (ID, CARD_NUMBER, OPEN_CASHBACK, CLOSE_CASHBACK) values (27, '3540000000001312', '07-SEP-22 05.47.12.000000 PM', null); insert into CASHBACK_PERIOD (ID, CARD_NUMBER, OPEN_CASHBACK, CLOSE_CASHBACK) values (25, '3540000000001312', null, '07-SEP-22 04.02.19.000000 PM'); insert into CASHBACK_PERIOD (ID, CARD_NUMBER, OPEN_CASHBACK, CLOSE_CASHBACK) values (26, '3540000000001312', null, '07-SEP-22 04.02.50.000000 PM'); insert into CASHBACK_PERIOD (ID, CARD_NUMBER, OPEN_CASHBACK, CLOSE_CASHBACK) values (23, '3540000000001312', '07-SEP-22 03.54.42.000000 PM', null); insert into CASHBACK_PERIOD (ID, CARD_NUMBER, OPEN_CASHBACK, CLOSE_CASHBACK) values (24, '3540000000001312', null, '07-SEP-22 04.01.59.000000 PM'); SELECT * FROM cashback_period; SELECT (SELECT MAX(cd.open_cashback) FROM cashback_period cd) AS max_date, cc.* FROM cashback_period cc WHERE cc.close_cashback IS NULL; SELECT cc.open_cashback as max_date, cc.* FROM cashback_period cc WHERE open_cashback = (SELECT MAX(cd.open_cashback) FROM cashback_period cd) or close_cashback IS NULL;