I'm making an sql query that will run on a Postgresql DB and I need some help.
My query will give me the following data
YEAR ---- MONTH ---- COUNT
This information is grouped on year and month obviously and covers a few years. My problem is that I only wish to obtain three lines from each year, the three lines with the highest count that year. Is there a simple way of doing this ?