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. Case in Select Statement
  50. What is a stored procedure?
  51. What do Clustered and Non-Clustered index actually mean?
  52. Conversion failed when converting date and/or time from character string while inserting datetime
  53. Self Join to get employee manager name
  54. How do I UPDATE from a SELECT in SQL Server?
  55. Conversion failed when converting date and/or time from character string while inserting datetime
  56. When should I use CROSS APPLY over INNER JOIN?
  57. Insert Data Into Temp Table with Query
  58. error, string or binary data would be truncated when trying to insert
  59. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  60. NOT IN vs NOT EXISTS
  61. Must declare the scalar variable
  62. Must declare the scalar variable
  63. Rename column SQL Server 2008
  64. Efficiently convert rows to columns in sql server
  65. How to delete duplicate rows in SQL Server?
  66. Nested select statement in SQL Server
  67. SQL Query with NOT LIKE IN
  68. How do I escape a single quote in SQL Server?
  69. T-SQL split string based on delimiter
  70. Drop a temporary table if it exists
  71. How do I escape a single quote in SQL Server?
  72. How Stuff and ‘For Xml Path’ work in SQL Server?
  73. Data source name not found, and no default driver specified
  74. IDENTITY_INSERT is set to OFF – How to turn it ON?
  75. An attempt was made to access a socket in a way forbidden by its access permissions
  76. Each GROUP BY expression must contain at least one column that is not an outer reference
  77. Optimistic vs. Pessimistic locking
  78. Sql Server equivalent of a COUNTIF aggregate function
  79. Inserting data into a temporary table
  80. Can a foreign key be NULL and/or duplicate?
  81. Why does NULL = NULL evaluate to false in SQL server
  82. When to use SELECT … FOR UPDATE?
  83. CREATE VIEW must be the only statement in the batch
  84. SQL Server FOR EACH Loop
  85. Difference between JOIN and INNER JOIN
  86. The target principal name is incorrect. Cannot generate SSPI context
  87. The EXECUTE permission was denied on the object ‘xxxxxxx’, database ‘zzzzzzz’, schema ‘dbo’
  88. BCP error “Unable to open BCP host data-file”
  89. How can I clone an SQL Server database on the same server in SQL Server 2008 Express?
  90. “CASE” statement within “WHERE” clause in SQL Server 2008
  91. Get day of week in SQL Server 2005/2008
  92. How to join two tables by multiple columns in SQL?
  93. Warning: Null value is eliminated by an aggregate or other SET operation in Aqua Data Studio
  94. What is the difference between Scope_Identity(), Identity(), @@Identity, and Ident_Current()?
  95. incorrect syntax error CREATE VIEW must be the only statement in the batch
  96. SQL Server : error converting data type varchar to numeric
  97. Sql Server string to date conversion
  98. Check if table exists in SQL Server
  99. Conversion failed when converting from a character string to uniqueidentifier – Two GUIDs
  100. Operand type clash: int is incompatible with date + The INSERT statement conflicted with the FOREIGN KEY constraint

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)