Subject RE: [firebird-support] COMPUTE
Author Alan McDonald
> I wanna implement this SQL satement in FireBird. Is that possible ?
>
>
>
>
>
> 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