Monday, December 19, 2022

1+NULL SQL Intreview question

 ---Product base interview question
--Mention the output.
-- #15day SQL CHALLENGE


--DAY-3
---Please  Findout the below question & answer--------------------------------------------------


SELECT 1+NULL --NULL
SELECT '1'+NULL --NULL
SELECT '1'+'NULL' --1NULL
SELECT 1+'NULL' --Conversion failed when converting the varchar value 'NULL' to data type int.


-----------------------------------------END -----------------------------------------------------------

No comments:

Post a Comment

"๐Ÿš€ Delta Lake's Vectorized Delete: The Secret to 10x Faster Data Operations!"

"๐Ÿš€ Delta Lake's Vectorized Delete: The Secret to 10x Faster Data Operations!" Big news for data engineers! Delta Lake 2.0+ in...