SELECT AVG (CASE WHEN Value <> 0 THEN Value ELSE NULL END) …. AVG function will not take into account NULL values. So you can also use this AVG (NULLIF(Value, 0))
Tag: average
Most Viewed Posts
- Get the User Name and Domain Name from an Email Address in SQL (704)
- Get the First and Last Word from a String or Sentence in SQL (698)
- How to select distinct rows in a datatable in C# (560)
- Add Constraint to SQL Table to ensure email contains @ (455)
- Average of all values in a column that are not zero in SQL (373)