File Library
Analytic Functions: Advanced Cases
Topic:
Developer's Toolkit
Owner:
Kim Berg Hansen
Date:
2014-06-24
Subtopic:
Tips and Techniques
This presentation is a set of advanced usecases of analytic functions showing use of RANK, DENSE_RANK, ROW_NUMBER, RATIO_TO_REPORT, LAG, REGR_SLOPE, ROWS BETWEEN, and more to efficiently solve actual real life tasks, such as top selling items, picking by FIFO, picking route, forecast sales, and more.
Download File
khansen.analyticfunctions.presentation.pdf
Become a member of ODTUG to gain access to more than 12,500 files in our technical database.
- Not a member? Click through to the topic of interest to browse a list of available presentations.
- Already a member? Log-in here to access the full database
Click here to see the Full Techincal Resource Database
