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...

Πλήρης περιγραφή

Λεπτομέρειες βιβλιογραφικής εγγραφής
Κύριος συγγραφέας: Bartholomew, Daniel (Συγγραφέας)
Συγγραφή απο Οργανισμό/Αρχή: SpringerLink (Online service)
Μορφή: Ηλεκτρονική πηγή Ηλ. βιβλίο
Γλώσσα:English
Έκδοση: Berkeley, CA : Apress : Imprint: Apress, 2017.
Θέματα:
Computer science.
Database management.
Computer Science.
Database Management.
Διαθέσιμο Online:Full Text via HEAL-Link
Πίνακας περιεχομένων:
  • 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.

Παρόμοια τεκμήρια