SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
with t1 (i,s) as (select 1, '1' from dual union all --select 2, '2' from dual --union all select 3, '3' from dual --union all --select 4, '4' from dual --union all --select 5, '5' from dual ) ,t2 (i,s) as ( select 1, '1' from dual union all select 3, '3' from dual ) select * from t2 where i = all (select i from t2) and i = 1
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear