Introduction to Oracle Analytical functions , rank , denserank.

In this video we tried to demonstrate how oracle anaytical function works. How to do Top N query with oracle's rank and dense_rank function.

Also explained is how outputs and functionality of rank and dense_rank differs , what should be used when.

The demonstration video is from Linux Mint OS and I have used my own Query Light application. Hope you find it enlightening.

 

Here are some of the screen prints. 

Use of Oracle Rank Analytical Function.

Oracle Top N Query using rank analytical functions.