MariaDB and MySQL Common Table Expressions and Window Functions Revealed

MariaDB and MySQL Common Table Expressions and Window Functions Revealed

Walk away from old-fashioned and cumbersome query approaches and answer your business intelligence questions through simple and powerful queries built on common table expressions (CTEs) and window functions. These new features in MariaDB and MySQL help you to write queries without having to wade thr...

Full description

Bibliographic Details
Main Author: Bartholomew, Daniel. author (author)
Format: eBook
Language:Inglés
Published: Berkeley, CA : Apress 2017.
Edition:1st ed. 2017.
Subjects:
MySQL (Electronic resource)
MariaDB.
Database management.
Database Management.
See on Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009630637106719
Table of Contents:
  • Part I: Common Table Expressions
  • 1. Basics of Common Table Expressions
  • 2. Non-Recursive Common Table Expressions
  • 3. Recursive Common Table Expressions
  • Part II: Window Functions
  • 4. Basics of Window Functions
  • 5. Recognizing Opportunities for Window Functions
  • 6. Window Functions in Practice
  • 7. Combining Window Functions and CTEs.

Similar Items