The Art of SQL by Stephane Faroult & Peter Robson
Author:Stephane Faroult & Peter Robson [Stephane Faroult]
Language: eng
Format: epub
Tags: COMPUTERS / Programming Languages / SQL
ISBN: 9780596555368
Publisher: O'Reilly Media
Published: 2008-12-16T16:00:00+00:00
Using OLAP functions
With databases, OLAP functions such as row_number( ) that we have already used in the self-joins situation can provide a satisfactory and sometimes even a more efficient way to answer the same question "what was the current value for one particular item at a given date?" (remember that OLAP functionality does, however, introduce a distinctly non-relational aspect to the proceedings[*]).
Note
OLAP functions belong to the non-relational layer of SQL. They represent the final, or almost final, step in query execution, since they have to operate on the post-retrieval result set after the filtering has completed.
Download
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.
Deep Learning with Python by François Chollet(12593)
Hello! Python by Anthony Briggs(9928)
OCA Java SE 8 Programmer I Certification Guide by Mala Gupta(9804)
The Mikado Method by Ola Ellnestam Daniel Brolund(9787)
Dependency Injection in .NET by Mark Seemann(9348)
Algorithms of the Intelligent Web by Haralambos Marmanis;Dmitry Babenko(8310)
Test-Driven iOS Development with Swift 4 by Dominik Hauser(7772)
Grails in Action by Glen Smith Peter Ledbrook(7705)
The Well-Grounded Java Developer by Benjamin J. Evans Martijn Verburg(7567)
Becoming a Dynamics 365 Finance and Supply Chain Solution Architect by Brent Dawson(7185)
Microservices with Go by Alexander Shuiskov(6949)
Practical Design Patterns for Java Developers by Miroslav Wengner(6866)
Test Automation Engineering Handbook by Manikandan Sambamurthy(6811)
Secrets of the JavaScript Ninja by John Resig Bear Bibeault(6425)
Angular Projects - Third Edition by Aristeidis Bampakos(6228)
The Art of Crafting User Stories by The Art of Crafting User Stories(5744)
NetSuite for Consultants - Second Edition by Peter Ries(5672)
Demystifying Cryptography with OpenSSL 3.0 by Alexei Khlebnikov(5488)
Kotlin in Action by Dmitry Jemerov(5074)
