SQLize Online / PHPize Online  /  SQLtest Online

Share      Blog   Popular
Copy Format Clear
create table TEST_TEMP (NAME varchar(64), BIRTHDATE date); insert into TEST_TEMP values ('123', to_date('1990-01-03', 'YYYY-MM-DD')); insert into TEST_TEMP values ('456', to_date('1999-02-03', 'YYYY-MM-DD')); insert into TEST_TEMP values ('789', to_date('1990-03-03', 'YYYY-MM-DD')); insert into TEST_TEMP values ('987', to_date('1999-04-03', 'YYYY-MM-DD')); select * from test_temp; CREATE VIEW TEST AS SELECT * FROM TEST_TEMP OFFSET 0 ROWS FETCH NEXT 3 ROWS ONLY; create or replace view TEMP_COUNT1 as SELECT --+no_merge no_push_pred tbl.NAME, CASE WHEN EXTRACT(DAY FROM BIRTHDATE) IN (5, 12, 19, 26) AND 'false'='false' THEN 1 WHEN EXTRACT(DAY FROM BIRTHDATE) NOT IN (5, 12, 19, 26) AND 'false'='false' THEN 0 ELSE 1 END AS IS_CONTROL_GROUP FROM TEST tbl; select * from test; select * from temp_count1; SELECT COUNT(*) as cnt FROM TEMP_COUNT1 WHERE temp_count1.IS_CONTROL_GROUP = 0;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear