Re: Extracting data where a column is max

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: Extracting data where a column is max
Дата
Msg-id 20041227210348.GB29271@wolff.to
обсуждение исходный текст
Ответ на Re: Extracting data where a column is max  ("Keith Worthington" <keithw@narrowpathinc.com>)
Список pgsql-novice
On Mon, Dec 27, 2004 at 12:18:53 -0500,
  Keith Worthington <keithw@narrowpathinc.com> wrote:
> Hi Michael,
>
> I ended up with this query as I do not really care about the inventory_id in
> the end game.  What about SELECT DISTINCT is non-standard?  Are there any
> implications of using this other than portability?

It's the "ON" clause that is nonstandard. If you aren't worried about
portability than there isn't a problem with using that feature.

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

Предыдущее
От: Jaime Casanova
Дата:
Сообщение: Re: Rewritten queries
Следующее
От: "Keith Worthington"
Дата:
Сообщение: Calculating the difference between result columns