sql query formatting

From: Madis Priilinn <madp_at_math.ut.ee>
Date: Tue, 14 Aug 2001 16:42:47 +0200
Message-ID: <Pine.GSO.4.33.0108141634540.29500-100000@madli.ut.ee>

Hello!

I would like to format one query. Right now it shows something like this example (grouped by first column):

DNAME JOB Total Empl Average Sa
--------------- --------- ---------- ----------

ACCOUNTING      CLERK              1      15600
ACCOUNTING      MANAGER            1      29400
ACCOUNTING      PRESIDENT          1      60000
ACCOUNTING      All Jobs           3      35000
RESEARCH        ANALYST            2      36000
RESEARCH        CLERK              2      11400
RESEARCH        MANAGER            1      35700
RESEARCH        All Jobs           5      26100

But my intention is to get something like this:

DNAME JOB Total Empl Average Sa
--------------- --------- ---------- ----------

ACCOUNTING      CLERK              1      15600
                MANAGER            1      29400
                PRESIDENT          1      60000
                All Jobs           3      35000
RESEARCH        ANALYST            2      36000
                CLERK              2      11400
                MANAGER            1      35700
                All Jobs           5      26100

I've searched several hours already but can't find anything...But I don't want to believe this is impossible to do :)

Thank You,

Madis Received on Tue Aug 14 2001 - 09:42:47 CDT