Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Pivot type query without aggregate function. Transposing

chris001Dec 14 2012 — edited Dec 14 2012
Hi experts,

Oracle 11g.

I have a table (see code example to reproduce), that has a date, a grouping, and the count of that grouping (determined in another query). I need a pivot type query, but, without the aggregate functions. This is just for a report display. I can not seem to figure this one out. Thanks for your help.
CREATE TABLE temp_task
AS
   SELECT TO_DATE ('15-NOV-2012') validation_date,
          'GROUP 1' AS group_number,
          42 AS monthly_count
     FROM DUAL
   UNION ALL
   SELECT TO_DATE ('14-DEC-2012') validation_date,
          'GROUP 1' AS group_number,
          33 AS monthly_count
     FROM DUAL
   UNION ALL
   SELECT TO_DATE ('15-NOV-2012') validation_date,
          'GROUP 2' AS group_number,
          10 AS monthly_count
     FROM DUAL
   UNION ALL
   SELECT TO_DATE ('14-DEC-2012') validation_date,
          'GROUP 2' AS group_number,
          32 AS monthly_count
     FROM DUAL
   UNION ALL
   SELECT TO_DATE ('15-NOV-2012') validation_date,
          'GROUP 3' AS group_number,
          7 AS monthly_count
     FROM DUAL
   UNION ALL
   SELECT TO_DATE ('14-DEC-2012') validation_date,
          'GROUP 3' AS group_number,
          9 AS monthly_count
     FROM DUAL;
Using only SQL I need to return the following:

VALIDATION_DATE | GROUP 1 | GROUP 2 | GROUP 3
11/15/2012 | 42 | 10 | 7
12/14/2012 | 33 | 32 | 9
This post has been answered by Frank Kulash on Dec 14 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 11 2013
Added on Dec 14 2012
3 comments
33,136 views