MySQL, MariaDB and Friends
Susanne Holzgraefe
Improve your SQL
Common Table Expressions (CTE) and Window Functions
Saturday 12:40-13:00
|
H.1301 (Cornil)
What are Common Table Expressions (CTEs) and Window Functions? Why do you need them? How to use them?
Correlated subselects are a pain, but your software needs them? You still could need recursive queries? You want an easy way for finding lagging or leading rows? The keywords are Common Table Expressions (CTE) and Window Functions. Finally, both, MariaDB and MySQL support them. After explaining functionality and use cases, the talk also will show the ease of use.