This video explains SQL Analytical Functions RANK(), DENSE_RANK and PARTITION_BY. It also shows examples of how to get the same results without using SQL Analytical Function. The difference in coding will scare you and terrify you. This is an extensive video, but I encourage you to watch it. - You will love it, I promise. It is an eye opener. You will be convinced that you need to use ANALYTICAL QUERIES in order to get a SQL job. No exceptions!!!
