Blog

Recursive CTE: The Elegance of Simplicity in SQL – 1

10 January 202412 February 2024 Manage AS400 with SQL, More in depth

Common Table Expressions (CTE) in SQL on IBM iSeries (AS/400) are a powerful and flexible tool for creating temporary, reusable queries, simplifying and improving the readability of complex SQL queries. Below are the articles in the CTE series (including this…

iSeries Sql – CTE Common Table Expressions – definitions and usage

10 January 202412 February 2024 Manage AS400 with SQL, More in depth

Common Table Expressions (CTE) in SQL on IBM iSeries (AS/400), as in other database management systems, are a powerful and flexible feature that allows you to create temporary, reusable queries within a larger SQL statement wide. They are particularly useful…