Rajeev Kumar
What is the output of the Following statement?

SELECT (NULL + 1+345) [Sum of NULL and value.]

By Rajeev Kumar in SQL Server on Jun 27 2023
  • Amit Mohanty
    Jun, 2023 30

    NULL

    • 1
  • Abhishek Maitrey
    Jul, 2023 1

    As per the given scenario, the output should be NULL but in case you want to ignore NULL and retrieve overall SUM of the other values, you can use IsNull() check and replace NULL with the 0 (zero) value.

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS