sub-limiting a query

Поиск
Список
Период
Сортировка
От Louis-David Mitterrand
Тема sub-limiting a query
Дата
Msg-id 20070217125634.GA20589@apartia.fr
обсуждение
Ответы Re: sub-limiting a query
Re: sub-limiting a query
Re: sub-limiting a query
Re: sub-limiting a query
Список pgsql-sql
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 по дате отправления: