I’m very excited to announce that my new book on Common Table Expressions (CTEs) and Window Functions in MariaDB 10.2+ and MySQL 8.0+ is now out! Please check it out and spread the word.
These two new features have been requested often over the years and they’re finally here. So I did what any reasonable person would do and wrote a book about them.
The book is filled with practical examples that you can follow along with, or not, at your leisure. By the end of the book you will have a solid understanding of what CTEs and Window Functions are, how to use them, and why they’re both awesome.