We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

Improve your SQL

Logo of FOSDEM VZWFOSDEM VZW
 Holzgraefe, Susanne

Formal Metadata

Title
Improve your SQL
Subtitle
Common Table Expressions (CTE) and Window Functions
Title of Series
Number of Parts
561
Author
License
CC Attribution 2.0 Belgium:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal purpose as long as the work is attributed to the author in the manner specified by the author or licensor.
Identifiers
Publisher
Release Date
Language

Content Metadata

Subject Area
Genre
Abstract
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.