|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Summing Values across Rows
Here's the situation: I have a table with 3 columns, with scoring data (1-5). I'd like to sum these values into a fourth total column.
What's the simpliest way to do this in SQL? thanks in advance. |
|
#2
|
||||
|
||||
|
Update YourTable
Set Total = Column1 + Column2 + Column3 |
|
#3
|
|||
|
|||
|
Thanks!!
Quote:
-- thanks blicci, your query worked like a charm. |
![]() |
| Viewing: ASP Free Forums > Database > SQL Development > Summing Values across Rows |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|