Re: sql query formatting

From: The Ghost <TheGhost_at_home.com>
Date: Tue, 14 Aug 2001 15:45:24 GMT
Message-ID: <oIbe7.4675$hO5.950564@news3.rdc1.on.home.com>

break on dname;
your query;

"Madis Priilinn" <madp_at_math.ut.ee> wrote in message news:Pine.GSO.4.33.0108141634540.29500-100000_at_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 - 10:45:24 CDT