Getting average from 3 columns in MS SQL

Posted by barbarian on Stack Overflow See other posts from Stack Overflow or by barbarian
Published on 2010-03-15T16:27:06Z Indexed on 2010/03/15 16:29 UTC
Read the original article Hit count: 106

Filed under:
|
|

I have table with 3 columns(smallint) in MS SQL 2005.

Table Ratings
ratin1 smallint,
ratin2 smallint
ratin3 smallint

These columns can have values from 0 to 5

How to select average value of these fields, but only compare fields where value is greater then 0.

So if column values are 1,3,5 - average had to be 3 if values are 0,3,5 - average had to be 4

© Stack Overflow or respective owner

Related posts about mssql-2005

Related posts about tsql