Subject | RE: [firebird-support] COMPUTE |
---|---|
Author | Alan McDonald |
Post date | 2004-10-30T01:12:42Z |
> I wanna implement this SQL satement in FireBird. Is that possible ?SELECT SALESMAN, CLIE, SUM(IMPORT), AVG(IMPORT) FROM INQUIRED GROUP BY
>
>
>
>
>
> 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]
SALESMAN, CLIE