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 null, '3' from dual ) select 1+null, 2-null, 3||null, '4'||null, 5*null, 6/null ,count(i) over(partition by 1) from t2 --where i = all (select i from t2 where i = 1) -- and i = 1
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear