sub-limiting a query

Поиск
Список
Период
Сортировка
Hello,

I've got a table of shows with different types (movie, theater, 
ballet,etc.) and I am looking for a select that can return the 10 last 
entered shows AND at most 2 of each type. Is that possible in one query?

The table looks basically like:
created_on      | timestamp without time zone show_name       | text id_show         | integer
show_type      | text                        id_show_subtype | integer                     
 


В списке pgsql-sql по дате отправления: