WITH RECURSIVE PADRE AS ( SELECT COD_CTA, DES_CTA FROM CATALOGO WHERE COD_CTA=:COD_CTA UNION ALL SELECT e.COD_CTA, e.DES_CTA FROM CATALOGO e INNER JOIN padre p ON POSITION(e.COD_CTA, p.COD_CTA) = 1 AND p.COD_CTA > COD_CTA ROWS 1 ) SELECT DISTINCT cod_cta FROM PADRE WHERE COD_CTA < :COD_CTA
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter