07 – CTE (Common Table Expressions)

Theory

Performance considerations

Use cases

Task

Full Working Code

`src/test/java/com/example/demo/repository/CteTest.java`

Expected Output

Duplicate detection:

Recursive numbers:

Pagination with total:

Verification Steps