Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group