Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL help please

Re: SQL help please

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Fri, 14 Jan 2005 20:09:31 -0800
Message-ID: <41e8976f$1_2@127.0.0.1>


bhargav.desai_at_gmail.com wrote:

> Hello Gurus,
>
> I am trying to do following. I have a table that contains field
> table1.Blanace (Numeric). On this field I want to write a SQL query
> that gives me count and sum on ranges.
>
> For example,
>
> Balance Range Count Sum
> 200-300 5 $1255.00
> 100-200 2 $179.25
> less then 100 456 $4464.25
>
> Thanks in Advance

This is school work. Post your best attempt and enough of the table structure and data so we can see what you are working with.

You will get hints ... not answers.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Fri Jan 14 2005 - 22:09:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US