1. Window Perform: The RANK() perform is a window function, meaning it performs calculations across a set of table rows which have been relevant to the current row. It really works with PARTITION BY and ORDER BY to determine the subset of data and also the order by which ranks https://catgeneralcontractingllc.com