Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Posts
    4

    Unanswered: Script Conversion

    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 help

  2. #2
    Join Date
    May 2002
    Posts
    4
    Never mind....

    I discovered that DB2 doesn't support "Compute" rows



    __________________________
    Help Cure Cancer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •