Ranking your results: using RANK, DENSE_RANK and ROW_NUMBER In this article Iâm going to explain the use of the analytic functions RANK, DENSE_RANK and ROW_NUMBER to rank the results of your query. Consider the following query:
Imperialism is an action that involves a country (usually an empire or a kingdom) extending its power by the acquisition of territories. It may also include the exploitation of these territories, an action that is linked to colonialism.
uncountable noun. 1  Imperialism is a system in which a rich and powerful country controls other countries, or a desire for control over other countries. 2  the policy or practice of extending a state's rule over other territories. 3  an instance or policy of aggressive behaviour by one state against another.