Advertisement

What is LIKE || NULL || NOT NULL in Query - SQL Series Series - Part 3

What is LIKE || NULL || NOT NULL in Query - SQL Series Series - Part 3 In this video, we will learn about: LIKE patterns in SQL with % and _ patterns.

Some Examples:
--select * from Customer where Name LIKE 'TOM%';
--select * from Customer where Name LIKE '%y';
--select * from Customer where Name LIKE '%om%';
--select * from Customer where Name LIKE '_h%';
--select * from Customer where Name LIKE 'T__%';
--select * from Customer where Name LIKE 'T%y';

----Also, we will learn about IS NULL and IS NOT NULL in SQL to deal with NULL values in Columns in DB Table.

~~~Subscribe to this channel, and press bell icon to get some interesting videos on Selenium and Automation:


Follow me on my Facebook Page:


Let's join our Automation community for some amazing knowledge sharing and group discussion on Telegram:


WebServices API Automation Tutorials:

What is LIKE,What is LIKE in SQL,LIKE in SQL,LIKE with %,Like with _ in SQL,IS NULL in SQL,IS NOT NULL in SQL,SQL Tutorials,Naveen AutomationLabs,

Post a Comment

0 Comments