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.
When, during the course of the 19th century, the Italians, Belgians and Germans raised a claim to their share of the world in addition to the old colonial powers, the term Imperialism became an ideologically loaded and overall imprecise, but probably irreplaceable historiographical concept. 7 During the phase of High Imperialism between 1870 and World War I, every larger European nation state as well as the USA and Japan participated in acquiring territories outside Europe.