Difference between is and = in SQL? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 1

Difference between is and = in SQL?

18th Aug 2023, 6:57 AM
Ameya Ladda
Ameya Ladda - avatar
2 Answers
+ 2
Ameya Ladda I saw this post, this may answer your question. My code is made with Python, which is not the language you mentioned in your question. "in SQL, IS and = works the same, except IS can be used for value of type NULL, while = can't." https://stackoverflow.com/questions/59537602/in-sql-is-there-a-difference-between-is-and-when-returning-values-in-wher
18th Aug 2023, 7:21 AM
Dragon RB
Dragon RB - avatar
+ 1
Thank you for explanation! 👍🏻🙂
18th Aug 2023, 7:19 AM
Ameya Ladda
Ameya Ladda - avatar