Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vshal
Starting Member
3 Posts |
 Posted - 2008-07-29 : 22:25:40
|
| Hi Guys,I am kinda brand spanking new to SQL and don't know too much other than some simple SELECT statements.I have a table with the following columnsEntry No - Primary KeyAccount No - VARCHAR(20)Date - DATETIMEAmount - DECIMAL(8,2)There are many rows in the table and the Account No repeats in many rows as it is not the primary key. The range is from 1000 to 5000.What I would like to do is to SUM the Amounts of Accounts between 1000 to 2000 and SUM the Amounts of Accounts between 2500 to 3500. Then divide the 1st SUM result with the 2nd SUM result.This might be a piece of cake but I have been trying to work my way since almost a day now.thanks people, appreciate your inputs. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-07-29 : 23:23:14
|
[code]select sum(case when AccountNo between '1000' and '2000' then amount else 0 end) / sum(case when AccountNo between '2500' and '3500' then amount else 0 end) from table[/code]
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
|
|
Sum amounts of different ranges in the same table