SQL IN Operator

Опубликовано: 19 Май 2023
на канале: SQL Learning Resources: Dr. Cecelia Allison

318

SQL IN Operator

This video demonstrates how to use the SQL IN operator vs the equal sign (=). The SQL IN operator is used on a single value, multiple values, and in conjunction with the NOT operator in this video. The SQL IN operator is a logical operator that allows you to specify multiple values in a WHERE clause. The SQL IN operator is used to filter the result set based on whether a specified value matches any value in a list.

PLEASE SUPPORT THE CHANNEL 🔔 SUBSCRIBE 🔔
╰┈➤    / @sqlchannel

Learn SQL Skills Fast with a "Practice Database"!
   • Learn SQL Fast 🚀

Turn SQL programming into a Relaxing, Productive Journey:
   • Lofi Music for Studying 🎧📚

▶️ QUERY EXAMPLES:

► QUERY IMPLEMENTING THE EQUAL SIGN:

SELECT PlanID, PlanName, PlanDescription
FROM ServicePlans
WHERE PlanID = 'W1001'OR PlanID ='D2202'OR PlanID ='D1003'OR PlanID ='L2002';

► QUERY IMPLEMENTING THE IN OPERATOR:

SELECT PlanID, PlanName, PlanDescription
FROM ServicePlans
WHERE PlanID IN ('W1001','D2202','D1003','L2002');

► QUERY IMPLEMENTING THE NOT IN OPERATORS:

SELECT PlanID, PlanName, PlanDescription
FROM ServicePlans
WHERE PlanID NOT IN ('W1001','D2202','D1003','L2002');

► QUERY A SINGLE VALUE:

SELECT PlanID, PlanName, PlanDescription
FROM ServicePlans
WHERE PlanID IN ('W1001');

BOOST YOUR CAREER GROWTH!

🔹 Train for a Career in Data:
https://www.jaffainc.com/Entrepreneur...

🔹 OBTAIN "High-Rated" SQL Book which Simplifies SQL!
https://www.amazon.com/SQL-Simplified...

🔹 Access "Best Selling Tech Products, Books, Music, Movies & More"! https://www.jaffainc.com/hardware-sof...

🔹 Earn "SQL 🏅 Certifications & CEUs" (Continuing Education Units)
https://www.jaffainc.com/SQLCertifica...

#database #data #sql #sqlqueries #sqlforbeginners #sqltutorial #sqlcertificate #learnsql #sqltraining #sqlserver #relational #sqltips #sqlsyntax #sqlservertutorial #sqlcourse #practice #sqlpractice #sqlservertutorial #sqlservermanagementstudio #sqlskills