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 |
|
coldfiretech
Starting Member
30 Posts |
 Posted - 2009-06-28 : 23:45:52
|
| Okay, Say i have a table with a column called ProfileLimit. It can be anywhere between 1 and 12.How can I select that value from each row in the table and add them together.. So I can get the Total Amount??If I go SELECT ProfileLimit FROM Users it returns all the numbers i need, I just dont know how to add them all togther..Any ideas??Thanks!!!~Matt |
|
|
GhantaBro
Posting Yak Master
215 Posts |
Posted - 2009-06-29 : 00:08:37
|
| SELECT sum(ProfileLimit) total FROM Users |
 |
|
|
coldfiretech
Starting Member
30 Posts |
Posted - 2009-06-29 : 00:09:46
|
| Thank you!!! :)Sucess comes before work only in the dictionary. |
|
|
|
|
|
|
Add Column Value from every row to make total