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 по дате отправления: