Re: HELP, can't implement e filter

Hi guys,
thanks to everybody for your help. Sorry if I was not too goot at explaining
my problem, well, I have only the first table and I want to implement a
filter which returns the second one. The rule to implement is:
select only one c1 which has the max c2 and min c4, then display only c3,c4.
and c5 in ascendig way.
This is my solution, but I think I can improve it by using th Ben'suggestion
:

select c1,c2,c3,min(c4),min(c5)
-- see min c5 works on not significat values
from first_table
into tab_temp
group by c1,c2,c3
order by c1

select c1,max(c2),c3,c4,c5
into second_table
from tab_temp
group by c1,c3,c4,c5
order by c1,c4,c5

select c3,c4,c5 from second_table order by c3,c4,c5

--------- Original Message --------
Da: Ben Kim <bkim(at)tamu(dot)edu>
To:
Cc: pgsql-admin(at)postgresql(dot)org
Oggetto: Re: [ADMIN] HELP, can't implement e filter
Data: 20/08/07 16:15

>
>
>
> On Sun, 19 Aug 2007, giuseppe(dot)derossi(at)email(dot)it wrote:
>
> > Hi,
> > I need to implement a filter in order to select from the first table the
> > second one...
> > c1 c2 c3 c4 c5
> > 1)133659;1;"0039";"00121";7
> > 2)133664;1;"0039";"00121";12
> > 3)133664;2;"0039";"00121";12
> > 4)133665;2;"0039";"00121";12
> > 5)135460;1;"0039";"01152";
> > 6)135460;2;"0039";"01152";
> > 7)135471;1;"0050";"00153";4
> > 8)135471;2;"0050";"00153";4
> >
> > 1)133659;1;"0039";"00121";7
> > 3)133664;2;"0039";"00121";12
> > 4)133665;2;"0039";"00121";12
> > 6)135460;2;"0039";"01152";
> > 8)135471;2;"0050";"00153";4
>
> There should be something better but this might work.
>
> select * from testtable where (c1,c2) in (select c1, max(c2) from
> testtable group by c1 );
>
>
> HTH
>
> Ben K.
> Developer
> http://benix.tamu.edu
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
>
>
--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f

Sponsor:
Collezioni Moda Giro d’Italia Fashion. Approfitta dei saldi estivi. Sconti
dal 30 al 50%. Uomo, Donna e Bambino. Prodotto ufficiale.
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=6908&d=20070820