Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    3

    Question Unanswered: please help....

    Hello people,

    does anyone know how to make a frequency diagram with groups
    in Oracle? I have data like

    frequency size
    1 775
    2 780
    1 801

    my query for the data above is:

    SELECT COUNT(*) frequency,size
    FROM EMAIL
    GROUP BY size

    I would have data like

    frequency size
    3 700-800
    1 800-900
    Last edited by miggul; 11-11-03 at 09:42.

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: please help....

    Something like this:
    SELECT TO_CHAR(TRUNC(size,-2))||'-'||TO_CHAR(TRUNC(size,-2)+100) size, SUM(frequency)
    FROM email
    GROUP BY TRUNC(size,-2);

Posting Permissions

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