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