Subject | RE: [firebird-support] COMPUTE |
---|---|
Author | Alan McDonald |
Post date | 2004-10-30T04:09:25Z |
> so Guys...Why don't you write out a little table of field values and then show us what
> I consider that's not solve my little problem....
result you want from them
Alan
>
>
> > > SELECT Salesman, clie, import
> > >
> > > FROM inquired
> > >
> > > ORDER BY Salesman, clie
> > >
> > > COMPUTE SUM(import) BY Salesman, clie?.
> > >
> > > COMPUTE SUM(import), AVG(import) BY Salesman
> > >
> > >
> > > [Non-text portions of this message have been removed]
> >
> >
> > SELECT SALESMAN, CLIE, SUM(IMPORT), AVG(IMPORT) FROM INQUIRED GROUP BY
> > SALESMAN, CLIE
> >