In this article, we will learn how to use the IN and NOT IN operator with a SQL select query.
The IN operator can be used to specify multiple values in a WHERE clause.
The IN operator is a shorthand, to remove the need of multiple OR conditions.
Syntax
SELECT column_name(s) FROM TABLE_NAME WHERE column_name IN (value1, value2, ...valueN);
or
SELECT column_name(s) FROM TABLE_NAME WHERE column_name IN (SELECT STATEMENT);
Example-1
The subsequent statement would return all articles with a Title “Introduction” or “Concept of SQL”.
SELECT * FROM Article WHERE Title IN ('Introduction', 'Concept of SQL');
Example-2
The subsequent statement would return all articles that are from the same “TechID” as the technology.
SELECT * FROM Article WHERE TechID IN (SELECT ID FROM Technology);
Example-3
The subsequent statement would return all articles without a Title “Introduction” or “Concept of SQL”.
SELECT * FROM Article WHERE Title NOT IN ('Introduction', 'Concept of SQL');
Also, check How To Use LIKE Operator With Wildcard Characters In SQL
In this article, we have to show Create and Used PIPE in angular
In this article, we have to show Create and Used PIPE in angular
In this article, we have to show Create and Used PIPE in angular