How to delete 0 values but not blanks from a column in SQL Server 2008 programming?

by

Use AVG()

If you wish to ignore the 0 and include “blank” (if you mean NULL) to the base, you can make use of the following characteristic of the function:

AVG () computes the average of a set of values by dividing the sum of those values by the count of nonnull values.

So that

SELECT AVG(
    CASE WHEN [column] = 0 THEN NULL -- Skip 0 when calculate the average
         WHEN [column] IS NULL THEN 0 -- Include blank as 0 value
         ELSE [column] END) AS Average
FROM [table]

More Related Contents:

  1. Is it possible to write single query on two table which are not connected to each other?
  2. Can I Comma Delimit Multiple Rows Into One Column? [duplicate]
  3. Split function equivalent in T-SQL?
  4. Querying data by joining two tables in two database on different servers
  5. Is having an ‘OR’ in an INNER JOIN condition a bad idea?
  6. Where value in column containing comma delimited values
  7. How to find all connected subgraphs of an undirected graph
  8. How to use table variable in a dynamic sql statement?
  9. SQL query to split column data into rows
  10. Bulk DELETE on SQL Server 2008 (Is there anything like Bulk Copy (bcp) for delete data?)
  11. Create Trigger to log SQL that affected table?
  12. Transfer data from one database to another database
  13. How to find third or nᵗʰ maximum salary from salary table?
  14. SQL “between” not inclusive
  15. Can I set ignore_dup_key on for a primary key?
  16. Selecting first row per group
  17. Using PIVOT in SQL Server 2008
  18. sql group by only rows which are in sequence
  19. Function in SQL Server 2008 similar to GREATEST in mysql?
  20. How to retrieve field names from temporary table (SQL Server 2008)
  21. When using GETDATE() in many places, is it better to use a variable?
  22. SQL Server SELECT INTO @variable?
  23. How do I change db schema to dbo
  24. How to subtract 30 days from the current date using SQL Server
  25. Count records for every month in a year
  26. SQL Server: +(unary) operator on non-numeric Strings
  27. Use one CTE many times
  28. How to Select Every Row Where Column Value is NOT Distinct
  29. How to do a case sensitive GROUP BY?
  30. How to automatically generate unique id in SQL like UID12345678?

Leave a Comment