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.
In historical terms, imperialism is herein taken to refer to the subjugation of the states and societies of Africa, Asia, and the Pacific by the European powers during the nineteenth and twentieth centuries.