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