{He distinguished himself in a number of campaigns, specifically in the Peninsular war, and was elevated for the rank of field marshal. Together with the RANK() function in SQL, we could do this by incorporating the PARTITION BY search term and specifying the column for use for grouping the information. https://simonax4fy.bligblogging.com/28771788/considerations-to-know-about-rank