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.
HISTORY OF IMPERIALISM: Imperialism is found in the ancient histories of Assyrian Empire, Chinese Empire, Roman Empire, Greece, the Persian Empire, and the Ottoman Empire (Ottoman wars in Europe), ancient Egypt, and India and a basic component to the conquests of Genghis Khan and other warlords.