List:General Discussion« Previous MessageNext Message »
From:Volker Duetsch Date:December 11 2007 1:30pm
Subject:Selection of 2 peak-values and a fixed column
View as plain text  
Hi,

select 
    mnr, 
    kw, 
    sum(pzt), 
    sum(uu), 
    sum(u01), 
    sum(u02), 
    sum(u03) 
  from mde 
  where mnr=63210 group by kw, mnr


results in:

mnr	kw	sum(pzt)	sum(uu)	sum(u01)	sum(u02)	sum(u03)
63210   	02	7738	50	131	0	1086
63210   	03	7584	133	143	42	1162
63210   	04	7460	248	166	0	976
63210   	05	8921	159	76	0	689
63210   	06	8262	226	145	0	784
63210   	07	7708	146	91	22	1337

In every selection I need the column sum(pzt) and the 2 peak-values
of sum(u1), sum(u2) and sum(u3). The other value should be replaced
by zero.

e.g. for the first line (summ(uu) changed to 0)
mnr	kw	sum(pzt)	sum(uu)	sum(u01)	sum(u02)	sum(u03)
63210   	02	7738	0	131	0	1086

e.g. for the second line (no changes)
mnr	kw	sum(pzt)	sum(uu)	sum(u01)	sum(u02)	sum(u03)
63210   	02	7738	0	131	0	1086

e.g. for the third line (sum(uu) and sum(u02) changed to 0)
mnr	kw	sum(pzt)	sum(uu)	sum(u01)	sum(u02)	sum(u03)
63210   	03	7584	0	143	0	1162

I tried a combination of select .. greatest didn't deliver the
result I expected..

Can anyone point me to a solution?

regards
Volker



Thread
Selection of 2 peak-values and a fixed columnVolker Duetsch11 Dec
  • Re: Selection of 2 peak-values and a fixed columnRob Wultsch11 Dec