Timeline for Difference between inline view and WITH clause?
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 16, 2018 at 21:25 | comment | added | Lennart - Slava Ukraini |
In addition, a CTE can reference a previously declared CTE. A derived table can't reference a previously declared derived table at the same level unless LATERAL is used.
|
|
| May 2, 2017 at 19:27 | comment | added | a1ex07 | @JoishiBodio: Personally, I agree with you, but readability is quite a subjective matter. I'd rather avoid mentioning it | |
| May 2, 2017 at 16:35 | comment | added | Joishi Bodio | I'd like to add that, as a side benefit, using CTEs are generally more readable for humans as well. | |
| May 2, 2017 at 15:29 | comment | added | ypercubeᵀᴹ | MySQL (at least latest MariaDB versions) can materialize derived tables (and even add indexes). | |
| May 2, 2017 at 15:27 | vote | accept | Kshitiz Sharma | ||
| May 2, 2017 at 14:58 | history | answered | a1ex07 | CC BY-SA 3.0 |