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.

You are browsing past conference edition.