Re: Extracting data where a column is max

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Keith Worthington <keithw(at)narrowpathinc(dot)com>
Cc: Michael Fuhr <mike(at)fuhr(dot)org>, PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Extracting data where a column is max
Date: 2004-12-27 21:03:48
Message-ID: 20041227210348.GB29271@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Mon, Dec 27, 2004 at 12:18:53 -0500,
Keith Worthington <keithw(at)narrowpathinc(dot)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.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Keith Worthington 2004-12-27 21:46:15 Calculating the difference between result columns
Previous Message Jaime Casanova 2004-12-27 19:48:45 Re: Rewritten queries