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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 sum of values returned by sql query

Author  Topic 

mavericky
Posting Yak Master

117 Posts

Posted - 2011-08-23 : 10:23:03
Hi All,
I have a sql query which returns following values for 3 rows:
Name v1 v2 v3
Row1 A 2 2 2
Row2 B 3 3 3
Row3 C 4 4 4

Is there any way I can get a sum of v1, v2 and v3 values for all 3 rows and display in a single row?
So the result would be like this
v1 v2 v3
9 9 9

Thanks in anticipation,
Mavericky

mavericky
Posting Yak Master

117 Posts

Posted - 2011-08-23 : 10:40:05
This is solved. Thanks!
Go to Top of Page
   

- Advertisement -