How to find sum of multiple columns in a table in SQL Server 2005?

Easy:

SELECT 
   Val1,
   Val2,
   Val3,
   (Val1 + Val2 + Val3) as 'Total'
FROM Emp

or if you just want one row:

SELECT 
   SUM(Val1) as 'Val1',
   SUM(Val2) as 'Val2',
   SUM(Val3) as 'Val3',
   (SUM(Val1) + SUM(Val2) + SUM(Val3)) as 'Total'
FROM Emp

Related Posts:

  1. How to format a numeric column as phone number in SQL
  2. sql query to return differences between two tables
  3. Selecting COUNT(*) with DISTINCT
  4. Inserting multiple rows in a single SQL query? [duplicate]
  5. SQL query to select dates between two dates
  6. SQL query to get the employee name and their manager name from the same table
  7. How can I do an UPDATE statement with JOIN in SQL Server?
  8. T-SQL split string
  9. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  10. The SQL OVER() clause – when and why is it useful?
  11. Update multiple columns in SQL
  12. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  13. SQL Server IF EXISTS THEN 1 ELSE 2
  14. SQL Query with SUM with Group By
  15. How do I perform an IF…THEN in an SQL SELECT?
  16. SQL update from one Table to another based on a ID match
  17. Conversion of a varchar data type to a datetime data type resulted in an out-of-range value in SQL query
  18. How to drop all tables from a database with one SQL query?
  19. SQL Server : Arithmetic overflow error converting expression to data type int
  20. How to calculate percentage with a SQL statement
  21. Column name or number of supplied values does not match table definition
  22. Query comparing dates in SQL
  23. Best way to do nested case statement logic in SQL Server
  24. What is the meaning of the prefix N in T-SQL statements and when should I use it?
  25. The multi-part identifier could not be bound
  26. Query error with ambiguous column name in SQL
  27. How to drop all tables from a database with one SQL query?
  28. How can I delete using INNER JOIN with SQL Server?
  29. Conversion of a varchar data type to a datetime data type resulted in an out-of-range value in SQL query
  30. CREATE TABLE IF NOT EXISTS equivalent in SQL Server
  31. How to group by month from Date field using sql
  32. How can I get column names from a table in SQL Server?
  33. Is there a combination of “LIKE” and “IN” in SQL?
  34. Search text in stored procedure in SQL Server
  35. Add a column with a default value to an existing table in SQL Server
  36. What represents a double in sql server?
  37. What is the maximum characters for the NVARCHAR(MAX)?
  38. Difference between database and schema
  39. SQL – WHERE (X, Y) IN (A, B)
  40. How do I fix the error ‘Named Pipes Provider, error 40 – Could not open a connection to’ SQL Server’?
  41. SQL: IF clause within WHERE clause
  42. how to increment integer Columns value by 1 in SQL
  43. How to select the last record of a table in SQL?
  44. SQL- Ignore case while searching for a string
  45. “select * into table” Will it work for inserting data into existing table
  46. CASE IN statement with multiple values
  47. Using Excel VBA to run SQL query
  48. What is tableName.* in SQL
  49. What do Clustered and Non-Clustered index actually mean?
  50. Conversion failed when converting date and/or time from character string while inserting datetime
  51. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  52. NOT IN vs NOT EXISTS
  53. Must declare the scalar variable
  54. How do I escape a single quote in SQL Server?
  55. T-SQL split string based on delimiter
  56. Data source name not found, and no default driver specified
  57. Optimistic vs. Pessimistic locking
  58. Can a foreign key be NULL and/or duplicate?
  59. When to use SELECT … FOR UPDATE?
  60. Difference between JOIN and INNER JOIN
  61. The target principal name is incorrect. Cannot generate SSPI context
  62. The EXECUTE permission was denied on the object ‘xxxxxxx’, database ‘zzzzzzz’, schema ‘dbo’
  63. BCP error “Unable to open BCP host data-file”
  64. “CASE” statement within “WHERE” clause in SQL Server 2008
  65. What is the difference between Scope_Identity(), Identity(), @@Identity, and Ident_Current()?
  66. Conversion failed when converting from a character string to uniqueidentifier – Two GUIDs
  67. Operand type clash: int is incompatible with date + The INSERT statement conflicted with the FOREIGN KEY constraint
  68. Keeping it simple and how to do multiple CTE in a query
  69. How to upsert (update or insert) in SQL Server 2005
  70. DateTime2 vs DateTime in SQL Server
  71. Difference between numeric, float and decimal in SQL Server
  72. SQL Server Insert if not exists
  73. SQL Server: Invalid Column Name
  74. sql server invalid object name – but tables are listed in SSMS tables list
  75. What is the equivalent of ‘describe table’ in SQL Server?
  76. How do I query for all dates greater than a certain date in SQL Server?
  77. String or binary data would be truncated. The statement has been terminated
  78. Error converting data type varchar to float
  79. How to concatenate text from multiple rows into a single text string in SQL Server
  80. Count(*) vs Count(1) – SQL Server
  81. ClassNotFoundException – com.microsoft.jdbc.sqlserver.SQLServerDriver
  82. The SELECT permission was denied on the object ‘Users’, database ‘XXX’, schema ‘dbo’
  83. How do you open an SDF file (SQL Server Compact Edition)?
  84. Using RegEx in SQL Server
  85. Conversion failed when converting the varchar value ‘simple, ‘ to data type int
  86. What is the difference between a stored procedure and a view?
  87. Trouble Connecting to sql server Login failed. “The login is from an untrusted domain and cannot be used with Windows authentication”
  88. Bulk load data conversion error (truncation)
  89. ‘Microsoft.ACE.OLEDB.16.0’ provider is not registered on the local machine.
  90. How do I format a number with commas in T-SQL?
  91. SQL datetime compare
  92. SQL Server dynamic PIVOT query?
  93. Incorrect syntax near ”
  94. To add server using sp_addlinkedserver
  95. How to connect to a local database in SQL Server Management Studio?
  96. What are named pipes?
  97. INSERT VALUES WHERE NOT EXISTS
  98. How to implement LIMIT with SQL Server? [duplicate]
  99. Cannot insert explicit value for identity column in table ‘table’ when IDENTITY_INSERT is set to OFF
  100. How to dump a Microsoft SQL Server database to a SQL script?

Leave a Comment