Average of multiple columns

by

You don’t mention if the columns are nullable. If they are and you want the same semantics that the AVG aggregate provides you can do (2008)

SELECT *,
       (SELECT AVG(c)
        FROM   (VALUES(R1),
                      (R2),
                      (R3),
                      (R4),
                      (R5)) T (c)) AS [Average]
FROM   Request

The 2005 version is a bit more tedious

SELECT *,
       (SELECT AVG(c)
        FROM   (SELECT R1
                UNION ALL
                SELECT R2
                UNION ALL
                SELECT R3
                UNION ALL
                SELECT R4
                UNION ALL
                SELECT R5) T (c)) AS [Average]
FROM   Request

More Related Contents:

  1. Is it possible to write single query on two table which are not connected to each other?
  2. SET versus SELECT when assigning variables?
  3. How to print VARCHAR(MAX) using Print Statement?
  4. Convert Xml to Table SQL Server
  5. Concatenate values based on ID
  6. Splitting delimited values in a SQL column into multiple rows
  7. Cumulative Total in MS Sql server [duplicate]
  8. I dont know sql syntax for my table [closed]
  9. Get top 1 row of each group
  10. CROSS JOIN vs INNER JOIN in SQL
  11. Referring to a Column Alias in a WHERE Clause
  12. How to avoid the “divide by zero” error in SQL?
  13. Multiple INSERT statements vs. single INSERT with multiple VALUES
  14. Generate a resultset of incrementing dates in TSQL
  15. Real life example, when to use OUTER / CROSS APPLY in SQL
  16. Getting result of dynamic SQL into a variable for sql-server
  17. How to get difference between two rows for a column field?
  18. Better techniques for trimming leading zeros in SQL Server?
  19. Common Table Expression, why semicolon?
  20. What’s the best way to select the minimum value from several columns?
  21. T-SQL split string based on delimiter
  22. How can I determine the status of a job?
  23. Do clustered indexes have to be unique?
  24. How do I prevent a database trigger from recursing?
  25. How to combine results of two queries into a single dataset
  26. SQL take just the numeric values from a varchar
  27. Flattening of a 1 row table into a key-value pair table
  28. SQL Server equivalent of WM_CONCAT function [duplicate]
  29. Distributed transaction error?
  30. Determine what user created objects in SQL Server

Leave a Comment