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 2, '2' from dual union all select 3, '3' from dual ) select * from t1 where i in (select i from t2)
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear