Common Task: Ranking Data and Selecting Top n Records A common task for database developers is to rank a set of data and return the top n records – the top 5 companies per year by total sales volume, for example. Coming from a SQL Server background, this would typically be handled by a CTEContinue reading “Snowflake: Simplify Ranking Syntax with QUALIFY”