'How to perform aggregate function in SQL based on a condition of the data?
I have a table with fields RegionName, Month and Mo.Rent Price. Each row contains values for a city's average rent price in a particular month. I want to use a SQL Query to pull the cities that have the lowest rent prices for each month. In other words, I don't want to find the city with the min rent overall. I want the min rent from the other rent values in that month. And I want that for each month. Anyone know what query I could use? Thanks I attached the table im working with below
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|