Hey,
Here is an SQL script that works in Sybase and I need a script that does the same thing but works for DB2. Does anyone know what it is?
SELECT type, price, advance FROM test_table ORDER BY type COMPUTE SUM(price), SUM(advance) BY type
Thanks for you helpNever mind...
I discovered that DB2 doesn't support "Compute" rows
__________________________
Help Cure Cancer (http://www.scuzzy.refhost.net/HCC)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment