Re: Extracting data where a column is max - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: Extracting data where a column is max
Date
Msg-id 20041227210348.GB29271@wolff.to
Whole thread Raw
In response to Re: Extracting data where a column is max  ("Keith Worthington" <keithw@narrowpathinc.com>)
List 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 by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: Rewritten queries
Next
From: "Keith Worthington"
Date:
Subject: Calculating the difference between result columns