HomeНаука и техникаRelated VideosMore From: WingsOfTechnology

IS NULL Operator in SQL Query with Example

3 ratings | 3500 views
SQL IS NULL Operator: A column value is NULL if it does not exist. The IS NULL operator is used to display all the rows for columns that do not have a value. For Example: If you want to find the emp names who do not get any commision, the query would be as given below: select * from emp where COMM IS NULL; In the opposite way, NOT NULL also works here: select * from emp where COMM IS NOT NULL; Thanks for watching..:)
Html code for embedding videos on your blog
Text Comments (0)

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.