Welcome to Software Development on Codidact!

Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.

Posts tagged common-table-expression

Synonyms: cte

2 posts Subscribe

Tag Only Tag + Children

77%

+5 −0

Q&A How to break infinite loop in CTE

I have a parent-child relation in my table, with possibly circular cases. Is it possible to break the infinite recursion in CTE checking values of all previous rows? I would need something like thi...

3 answers · posted 3y ago by artaxerxe‭ · edited 15d ago by Michael‭

Question sql sql-server common-table-expression

71%

+3 −0

Q&A Conditions which always matches returns no result with CTE

I have the following scenario (in MySQL 8): CREATE TABLE `steps` ( `id` int NOT NULL AUTO_INCREMENT, `number` varchar(30) DEFAULT NULL, `parent_number` varchar(30) DEFAULT NULL, `timestamp` ti...

1 answer · posted 2y ago by artaxerxe‭ · edited 2y ago by Alexei‭

Question mysql common-table-expression

Tag RSS feed

Communities

Posts tagged common-table-expression

Synonyms: cte