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@xxxxxxxx> To: Cc: pgsql-admin@xxxxxxxxxxxxxx Oggetto: Re: HELP, can't implement e filter Data: 20/08/07 16:15 > > > > On Sun, 19 Aug 2007, giuseppe.derossi@xxxxxxxx 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
