Selection of 2 peak-values and a fixed column

2007-12-11 Thread Volker Duetsch
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 773850 131 0

Re: Selection of 2 peak-values and a fixed column

2007-12-11 Thread Rob Wultsch
On Dec 11, 2007 6:30 AM, Volker Duetsch [EMAIL PROTECTED] wrote: 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)