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 |
|
sponguru_dba
Yak Posting Veteran
93 Posts |
 Posted - 2006-01-12 : 02:47:23
|
| Hi allHere my data format ONE TWO THREE--------------------- 1 20 100 1 30 102 1 32 100 2 43 103 2 40 104 2 22 100 3 21 null 3 50 null | | | . . . 200from above based on column ONE iwant agreegation of TWO columnin above table 1 -- 822 -- 1053 -- 71:::100 -- something Advanced TahnksSree |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2006-01-12 : 02:50:55
|
SELECT ONE, SUM(TWO) GROUP BY ONEDuane.  "It's a thankless job, but I've got a lot of Karma to burn off." |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
sponguru_dba
Yak Posting Veteran
93 Posts |
Posted - 2006-01-12 : 03:33:48
|
| Thaking You ditch and madhivanan for help |
|
|
|
|
|
|
Can some body help me - Query writing