Postgres Pro
Downloads
Home   >   mailing lists

Re: Select the max on a field - Mailing list pgsql-sql

From Gaetano Mendola
Subject Re: Select the max on a field
Date
Msg-id alq427$2ta2$1@news.hub.org
Whole thread Raw
In response to Select the max on a field  ("Gaetano Mendola" <mendola@bigfoot.com>)
Responses Re: Select the max on a field  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
List pgsql-sql
Tree view 
"Gaetano Mendola" <mendola@bigfoot.com> wrote in message
news:alq3mr$2s7o$1@news.hub.org...
> Hi all,
>
> Suppose that I have a table like this:
>
>
> att_1  |    att_2 |    att_3 |  att_4
> --------------------------------
> 1       |      a      |    y       |    y1
> 2       |      b      |    y       |    y2
> 3       |      a      |    xx     |    y3
> 4       |      c      |    zz      |    y4
> 5       |      a      |    t        |    y5
> 6       |      c      |    x       |    y6
>
>
>
> I want obtain all row that have for each att_2
> the max of att_1

I forgot to say: "with a single total query without sub select "


Ciao
Gaetano

pgsql-sql by date:

Previous
From: "Gaetano Mendola"
Date:
Subject: Select the max on a field
Next
From: Stephan Szabo
Date:
Subject: Re: still sorting and casting problems