Re: oracle sql query - output one line?

captain_2010_at_yahoo.com wrote:
> hi,
>
> Below is the output required, how ?
>
> Total 1980 1981 1982 1983
> 20 1 3 5 2
>
>
> SQL written below gives output as
>
> TOTAL TO_C
> --------- ----
> 1 1980
> 10 1981
> 1 1982
> 1 1987
>
> SQL:
> select count(*) as Total,to_char(hiredate,'yyyy') from emp group by
> to_char(hiredate,'yyyy');
>
> How to get output as given above i.e. in one line.
>
> Captain

Type it into notepad.

There is no way to get the result above from the data below.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)