in keyword in sql code example

Example 1: sql where keyword

Filters results to only include data which meets the given condition.
Example: Returns orders with a quantity of more than 1 item.
SELECT * FROM orders
WHERE quantity > 1;

Example 2: where keyword sql

Where clause basically returns only 
true conditions

Select First_Name
From Customers
Where ID = 1905Cimbom;

Example 3: sql where multiple values

SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1, value2, ...);

Example 4: sql in

Used alongside a WHERE clause as a shorthand for multiple OR conditions.
So instead of:
SELECT * FROM users
WHERE country = 'USA' OR country = 'United Kingdom' OR
country = 'Russia' OR country = 'Australia';
You can use:
SELECT * FROM users
WHERE country IN ('USA', 'United Kingdom', 'Russia',
'Australia');

Example 5: in query in sql

SELECT Id, FirstName, LastName, Country  FROM Customer WHERE Country IN        (SELECT Country           FROM Supplier)

Example 6: in in sql

(IN) operator in sql like "OR" operator
For example: 
Select * From employees
Where department_id "IN" (60,90);