SELECT max(x) is returning null; how can I make it return 0?

by

or:

SELECT coalesce(MAX(X), 0) AS MaxX
FROM tbl
WHERE XID = 1

More Related Contents:

  1. Find number of days that intersect a given date range in a table of date ranges
  2. How to extrapolate dates in SQL Server to calculate the daily counts?
  3. Insert results of a stored procedure into a temporary table
  4. Best approach to remove time part of datetime in SQL Server
  5. Difference between JOIN and INNER JOIN
  6. Is there a way to access the “previous row” value in a SELECT statement?
  7. Remove Identity from a column in a table
  8. How to create multiple one to one’s
  9. efficient way to implement paging
  10. SQL Server – transactions roll back on error?
  11. Formatting Numbers by padding with leading zeros in SQL Server
  12. SQL Case Sensitive String Compare
  13. Difference between a User and a Login in SQL Server
  14. Exporting data In SQL Server as INSERT INTO
  15. Convert Comma Separated column value to rows
  16. SQL Server : dynamic pivot over 5 columns
  17. For Nvarchar(Max) I am only getting 4000 characters in TSQL?
  18. Postgres Case Sensitivity
  19. How do I query for all dates greater than a certain date in SQL Server?
  20. Check If the string contains accented characters in SQL?
  21. Count based on condition in SQL Server
  22. Does Sql JOIN order affect performance?
  23. What does sp_reset_connection do?
  24. Syntax of for-loop in SQL Server
  25. Using tuples in SQL “IN” clause
  26. Replace first occurrence of substring in a string in SQL
  27. Why does ISNUMERIC(‘.’) return 1?
  28. How to correctly insert newline in nvarchar [duplicate]
  29. How do you copy a record in a SQL table but swap out the unique id of the new row?
  30. Using IF ELSE statement based on Count to execute different Insert statements

Leave a Comment