Solving Max and Min Value Problems with SQL Window Functions

While working with databases, we might be in a situation to solve the problems related with handling max values or min values. "What product has been sold at highest price in last 5 years?", "Since 2000, who has hit the most home-runs in a season and which year was it?" or "On which date each… Continue reading Solving Max and Min Value Problems with SQL Window Functions