Re: SELECT statement not working as intended

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: SELECT statement not working as intended
Дата
Msg-id 4E937AB6.5010004@hogranch.com
обсуждение исходный текст
Ответ на Re: SELECT statement not working as intended  (Rich Shepard <rshepard@appl-ecosys.com>)
Ответы Re: SELECT statement not working as intended
Список pgsql-general
On 10/10/11 3:45 PM, Rich Shepard wrote:
>   As I asked Merlin, what is necessary to get the date that maximum
> quantity
> was recorded? A nested SELECT?

the complication is, there can be more than one date with the same
maximum value, so such a query would be ambiguous, or it would return
multiple rows.



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast


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

Предыдущее
От: Rich Shepard
Дата:
Сообщение: Re: SELECT statement not working as intended
Следующее
От: Bob Hatfield
Дата:
Сообщение: pg 8.3 replication causing corruption