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.
Its name originated from the Latin word imperium , which means to rule over large territories. Imperialism is a policy of extending a country's power and influence through colonization, use of military force, or other means. Imperialism has greatly shaped the contemporary world.