1. Window Perform: The RANK() Perform is actually a window perform, that means it performs calculations across a set of table rows that are related to The existing row. It works with PARTITION BY and ORDER BY to define the subset of data and the get wherein ranks are assigned. https://catgeneralcontractingllc.com