SELECT tmp1.* FROM tmp1 JOIN test_int_rep t1 ON t1.pid = tmp1.pid delete FROM recursive_001 using tmp1 WHERE recursive_001.id_int in (SELECT max(distinct tmp1.pid ...
WITH RECURSIVE tbl(a) USING KEY (a) AS (SELECT 1 UNION ALL SELECT a.a+1 FROM tbl AS a, (SELECT * FROM recurring.tbl AS d WHERE d.a = 1) AS b WHERE a.a < 2) SELECT * FROM tbl; WITH RECURSIVE tbl2(a, b) ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results