Test Your Microsoft SQL Server IN Operator Knowledge with This Quiz

Progress

True / False

The following query checks if the value 'USA' is present in the 'Country' column: SELECT * FROM Customers WHERE Country IN ('USA').

SQL Code

SELECT * FROM Customers
WHERE Country IN ('USA');

True False

The query correctly checks if 'USA' is in the 'Country' column of the 'Customers' table.

True / False

The IN operator can be used to check for multiple values in a column in a single query.

True False

The IN operator is used to specify multiple values in a WHERE clause.

True / False

The IN operator is case-sensitive in Microsoft SQL Server.

True False

The IN operator is case-sensitive depending on the collation of the column.

True / False

Using the IN operator, you can check for both numeric and string values in the same column.

SQL Code

SELECT * FROM Orders
WHERE OrderID IN (10248, '10349');

True False

The IN operator can be used with both numeric and string values, but not in the same column for the same query.

True / False

The query will return rows where the 'Status' column has values 'Active' or 'Pending': SELECT * FROM Projects WHERE Status IN ('Active', 'Pending').

SQL Code

SELECT * FROM Projects
WHERE Status IN ('Active', 'Pending');

True False

The query correctly uses the IN operator to filter rows where the 'Status' is either 'Active' or 'Pending'.

True / False

The following query returns all customers who are from either 'France' or 'Spain': SELECT * FROM Customers WHERE Country IN ('France', 'Spain').

SQL Code

SELECT * FROM Customers
WHERE Country IN ('France', 'Spain');

True False

The query correctly uses the IN operator to filter customers from 'France' or 'Spain'.

True / False

The IN operator can only be used with numeric values.

True False

The IN operator can be used with both numeric and string values.

True / False

The IN operator improves query performance by reducing the need for multiple OR conditions.

True False

The IN operator is more efficient than using multiple OR conditions as it simplifies the query.

True / False

The following query will return an error: SELECT * FROM Products WHERE CategoryID IN (1, 2, '3').

SQL Code

SELECT * FROM Products
WHERE CategoryID IN (1, 2, '3');

True False

The IN operator cannot mix data types in the same list.

Q10

True / False

The IN operator can be used within a subquery to filter results based on another table's values.

SQL Code

SELECT * FROM Employees
WHERE DepartmentID IN (SELECT DepartmentID FROM Departments WHERE Location = 'New York');

True False

The IN operator is commonly used with subqueries to filter results based on values from another table.

Q11

True / False

The following query checks for both 'Manager' and 'Employee' roles in the 'Role' column: SELECT * FROM Users WHERE Role IN ('Manager', 'Employee').

SQL Code

SELECT * FROM Users
WHERE Role IN ('Manager', 'Employee');

True False

The query uses the IN operator to filter users with roles 'Manager' or 'Employee'.

Q12

True / False

The IN operator can be used in an UPDATE statement to modify multiple rows at once.

SQL Code

UPDATE Employees
SET Status = 'Active'
WHERE EmployeeID IN (101, 102, 103);

True False

The IN operator is useful in UPDATE statements to apply changes to multiple rows based on a list of values.

Q13

True / False

Using the IN operator in a DELETE statement can remove multiple rows from a table.

SQL Code

DELETE FROM Orders
WHERE OrderID IN (201, 202, 203);

True False

The IN operator is effective in DELETE statements to remove multiple rows based on specified values.

Q14

True / False

The following query filters orders placed in the year 2020 or 2021: SELECT * FROM Orders WHERE YEAR(OrderDate) IN (2020, 2021).

SQL Code

SELECT * FROM Orders
WHERE YEAR(OrderDate) IN (2020, 2021);

True False

The query correctly uses the IN operator to filter orders placed in the specified years.

Q15

True / False

The IN operator can be used with NULL values in the list.

True False

The IN operator cannot be used with NULL values directly; it will not match NULLs.

Q16

Single Choice

Which query will correctly filter employees who belong to the 'Sales' or 'HR' department?

SQL Code

SELECT * FROM Employees
WHERE Department IN ('Sales', 'HR');

SELECT * FROM Employees WHERE Department = 'Sales' AND Department = 'HR'; SELECT * FROM Employees WHERE Department IN ('Sales', 'HR'); SELECT * FROM Employees WHERE Department = 'Sales' OR Department = 'HR';SELECT * FROM Employees WHERE Department LIKE 'Sales' OR Department LIKE 'HR';

The IN operator is used to filter rows where the 'Department' column matches either 'Sales' or 'HR'.

Q17

Single Choice

Which SQL query retrieves all products where the 'CategoryID' is either 1, 2, or 3?

SQL Code

SELECT * FROM Products
WHERE CategoryID IN (1, 2, 3);

SELECT * FROM Products WHERE CategoryID = 1 OR 2 OR 3; SELECT * FROM Products WHERE CategoryID IN (1, 2, 3); SELECT * FROM Products WHERE CategoryID BETWEEN 1 AND 3;SELECT * FROM Products WHERE CategoryID = ANY (1, 2, 3);

The query uses the IN operator to filter products with 'CategoryID' 1, 2, or 3.

Q18

Single Choice

How would you select customers from 'Germany' or 'France'?

SQL Code

SELECT * FROM Customers
WHERE Country IN ('Germany', 'France');

SELECT * FROM Customers WHERE Country = 'Germany' AND Country = 'France'; SELECT * FROM Customers WHERE Country LIKE 'Germany' OR 'France'; SELECT * FROM Customers WHERE Country IN ('Germany', 'France');SELECT * FROM Customers WHERE Country = 'Germany' OR Country = 'France';

The IN operator filters customers from either 'Germany' or 'France'.

Q19

Single Choice

Which query checks for order dates in January, February, or March?

SQL Code

SELECT * FROM Orders
WHERE MONTH(OrderDate) IN (1, 2, 3);

SELECT * FROM Orders WHERE OrderDate = 'January' OR 'February' OR 'March'; SELECT * FROM Orders WHERE OrderDate IN ('January', 'February', 'March'); SELECT * FROM Orders WHERE MONTH(OrderDate) BETWEEN 1 AND 3;SELECT * FROM Orders WHERE MONTH(OrderDate) IN (1, 2, 3);

The query uses the IN operator to filter orders placed in January, February, or March.

Q20

Single Choice

Which query retrieves orders with a status of 'Shipped', 'Pending', or 'Cancelled'?

SQL Code

SELECT * FROM Orders
WHERE Status IN ('Shipped', 'Pending', 'Cancelled');

SELECT * FROM Orders WHERE Status LIKE 'Shipped' OR 'Pending' OR 'Cancelled'; SELECT * FROM Orders WHERE Status = 'Shipped' OR 'Pending' OR 'Cancelled'; SELECT * FROM Orders WHERE Status IN ('Shipped', 'Pending', 'Cancelled');SELECT * FROM Orders WHERE Status = ANY ('Shipped', 'Pending', 'Cancelled');

The query correctly uses the IN operator to filter orders with the specified statuses.

Q21

Single Choice

How do you find employees who have the job title 'Manager' or 'Engineer'?

SQL Code

SELECT * FROM Employees
WHERE JobTitle IN ('Manager', 'Engineer');

SELECT * FROM Employees WHERE JobTitle = 'Manager' AND JobTitle = 'Engineer'; SELECT * FROM Employees WHERE JobTitle IN ('Manager', 'Engineer'); SELECT * FROM Employees WHERE JobTitle LIKE 'Manager' OR 'Engineer';SELECT * FROM Employees WHERE JobTitle = 'Manager' OR JobTitle = 'Engineer';

The IN operator filters employees with the job title 'Manager' or 'Engineer'.

Q22

Single Choice

Which query will return products that are in categories 1, 4, or 5?

SQL Code

SELECT * FROM Products
WHERE CategoryID IN (1, 4, 5);

SELECT * FROM Products WHERE CategoryID = 1 OR CategoryID = 4 OR CategoryID = 5; SELECT * FROM Products WHERE CategoryID IN (1, 4, 5); SELECT * FROM Products WHERE CategoryID BETWEEN 1 AND 5;SELECT * FROM Products WHERE CategoryID = ANY (1, 4, 5);

The query uses the IN operator to filter products in categories 1, 4, or 5.

Q23

Single Choice

How do you select orders made by customers from 'UK', 'USA', or 'Canada'?

SQL Code

SELECT * FROM Orders
WHERE CustomerCountry IN ('UK', 'USA', 'Canada');

SELECT * FROM Orders WHERE CustomerCountry = 'UK' OR 'USA' OR 'Canada'; SELECT * FROM Orders WHERE CustomerCountry IN ('UK', 'USA', 'Canada'); SELECT * FROM Orders WHERE CustomerCountry = 'UK' AND 'USA' AND 'Canada';SELECT * FROM Orders WHERE CustomerCountry LIKE 'UK' OR 'USA' OR 'Canada';

The IN operator filters orders made by customers from 'UK', 'USA', or 'Canada'.

Q24

Single Choice

Which query retrieves employees who are part of 'Finance', 'Marketing', or 'IT' departments?

SQL Code

SELECT * FROM Employees
WHERE Department IN ('Finance', 'Marketing', 'IT');

SELECT * FROM Employees WHERE Department = 'Finance' AND 'Marketing' AND 'IT'; SELECT * FROM Employees WHERE Department LIKE 'Finance' OR 'Marketing' OR 'IT'; SELECT * FROM Employees WHERE Department IN ('Finance', 'Marketing', 'IT');SELECT * FROM Employees WHERE Department = 'Finance' OR Department = 'Marketing' OR Department = 'IT';

The IN operator is used to filter employees from 'Finance', 'Marketing', or 'IT' departments.

Q25

Single Choice

How do you find orders where the 'OrderID' is 10, 20, or 30?

SQL Code

SELECT * FROM Orders
WHERE OrderID IN (10, 20, 30);

SELECT * FROM Orders WHERE OrderID = 10 AND 20 AND 30; SELECT * FROM Orders WHERE OrderID = ANY (10, 20, 30); SELECT * FROM Orders WHERE OrderID IN (10, 20, 30);SELECT * FROM Orders WHERE OrderID LIKE 10 OR 20 OR 30;

The IN operator filters orders with 'OrderID' 10, 20, or 30.

Q26

Single Choice

Which query retrieves products from suppliers located in 'China', 'India', or 'Brazil'?

SQL Code

SELECT * FROM Products
WHERE SupplierCountry IN ('China', 'India', 'Brazil');

SELECT * FROM Products WHERE SupplierCountry LIKE 'China' OR 'India' OR 'Brazil'; SELECT * FROM Products WHERE SupplierCountry = 'China' AND SupplierCountry = 'India' AND SupplierCountry = 'Brazil'; SELECT * FROM Products WHERE SupplierCountry = ANY ('China', 'India', 'Brazil');SELECT * FROM Products WHERE SupplierCountry IN ('China', 'India', 'Brazil');

The query uses the IN operator to filter products from suppliers in 'China', 'India', or 'Brazil'.

Q27

Single Choice

How do you select customers whose 'City' is either 'New York', 'Los Angeles', or 'Chicago'?

SQL Code

SELECT * FROM Customers
WHERE City IN ('New York', 'Los Angeles', 'Chicago');

SELECT * FROM Customers WHERE City = 'New York' OR 'Los Angeles' OR 'Chicago'; SELECT * FROM Customers WHERE City IN ('New York', 'Los Angeles', 'Chicago'); SELECT * FROM Customers WHERE City = ANY ('New York', 'Los Angeles', 'Chicago');SELECT * FROM Customers WHERE City LIKE 'New York' OR 'Los Angeles' OR 'Chicago';

The IN operator filters customers whose 'City' is 'New York', 'Los Angeles', or 'Chicago'.

Q28

Single Choice

Which query checks if the 'OrderID' is in the list (1001, 1002, 1003)?

SQL Code

SELECT * FROM Orders
WHERE OrderID IN (1001, 1002, 1003);

SELECT * FROM Orders WHERE OrderID = 1001 OR 1002 OR 1003; SELECT * FROM Orders WHERE OrderID = ANY (1001, 1002, 1003); SELECT * FROM Orders WHERE OrderID IN (1001, 1002, 1003);SELECT * FROM Orders WHERE OrderID LIKE 1001 OR 1002 OR 1003;

The IN operator filters orders where 'OrderID' is 1001, 1002, or 1003.

Q29

Single Choice

How do you find suppliers located in 'USA', 'Canada', or 'Mexico'?

SQL Code

SELECT * FROM Suppliers
WHERE Country IN ('USA', 'Canada', 'Mexico');

SELECT * FROM Suppliers WHERE Country = 'USA' AND 'Canada' AND 'Mexico'; SELECT * FROM Suppliers WHERE Country LIKE 'USA' OR 'Canada' OR 'Mexico'; SELECT * FROM Suppliers WHERE Country IN ('USA', 'Canada', 'Mexico');SELECT * FROM Suppliers WHERE Country = ANY ('USA', 'Canada', 'Mexico');

The IN operator filters suppliers located in 'USA', 'Canada', or 'Mexico'.

Q30

Single Choice

Which query retrieves employees with 'JobTitle' in 'Analyst', 'Developer', or 'Consultant'?

SQL Code

SELECT * FROM Employees
WHERE JobTitle IN ('Analyst', 'Developer', 'Consultant');

SELECT * FROM Employees WHERE JobTitle = 'Analyst' AND 'Developer' AND 'Consultant'; SELECT * FROM Employees WHERE JobTitle LIKE 'Analyst' OR 'Developer' OR 'Consultant'; SELECT * FROM Employees WHERE JobTitle = ANY ('Analyst', 'Developer', 'Consultant');SELECT * FROM Employees WHERE JobTitle IN ('Analyst', 'Developer', 'Consultant');

The IN operator is used to filter employees with 'JobTitle' in 'Analyst', 'Developer', or 'Consultant'.

Q31

Multiple Choice

Select customers from 'Spain', 'Portugal', or 'Italy' using the IN operator.

SQL Code

SELECT * FROM Customers
WHERE Country IN ('Spain', 'Portugal', 'Italy');

SELECT * FROM Customers WHERE Country = 'Spain' AND 'Portugal' AND 'Italy'; SELECT * FROM Customers WHERE Country LIKE 'Spain' OR 'Portugal' OR 'Italy'; SELECT * FROM Customers WHERE Country IN ('Spain', 'Portugal', 'Italy');SELECT * FROM Customers WHERE Country = 'Spain' OR Country = 'Portugal' OR Country = 'Italy';

The IN operator filters customers from 'Spain', 'Portugal', or 'Italy'.

Q32

Multiple Choice

How do you retrieve orders with 'OrderStatus' of 'Pending', 'Approved', or 'Rejected'?

SQL Code

SELECT * FROM Orders
WHERE OrderStatus IN ('Pending', 'Approved', 'Rejected');

SELECT * FROM Orders WHERE OrderStatus = 'Pending' OR 'Approved' OR 'Rejected'; SELECT * FROM Orders WHERE OrderStatus LIKE 'Pending' OR 'Approved' OR 'Rejected'; SELECT * FROM Orders WHERE OrderStatus IN ('Pending', 'Approved', 'Rejected');SELECT * FROM Orders WHERE OrderStatus = 'Pending' AND 'Approved' AND 'Rejected';

The query uses the IN operator to filter orders with 'OrderStatus' of 'Pending', 'Approved', or 'Rejected'.

Q33

Multiple Choice

Which query selects products where 'ProductID' is in (101, 102, 103)?

SQL Code

SELECT * FROM Products
WHERE ProductID IN (101, 102, 103);

SELECT * FROM Products WHERE ProductID = 101 OR 102 OR 103; SELECT * FROM Products WHERE ProductID IN (101, 102, 103); SELECT * FROM Products WHERE ProductID LIKE 101 OR 102 OR 103;SELECT * FROM Products WHERE ProductID = ANY (101, 102, 103);

The IN operator filters products with 'ProductID' 101, 102, or 103.

Q34

Multiple Choice

How do you find employees working in 'HR', 'Finance', or 'Operations' departments?

SQL Code

SELECT * FROM Employees
WHERE Department IN ('HR', 'Finance', 'Operations');

SELECT * FROM Employees WHERE Department LIKE 'HR' OR 'Finance' OR 'Operations'; SELECT * FROM Employees WHERE Department = 'HR' AND 'Finance' AND 'Operations'; SELECT * FROM Employees WHERE Department = ANY ('HR', 'Finance', 'Operations');SELECT * FROM Employees WHERE Department IN ('HR', 'Finance', 'Operations');

The IN operator filters employees working in 'HR', 'Finance', or 'Operations' departments.

Q35

Multiple Choice

Select suppliers from 'Germany', 'France', or 'UK' using the IN operator.

SQL Code

SELECT * FROM Suppliers
WHERE Country IN ('Germany', 'France', 'UK');

SELECT * FROM Suppliers WHERE Country LIKE 'Germany' OR 'France' OR 'UK'; SELECT * FROM Suppliers WHERE Country = 'Germany' AND 'France' AND 'UK'; SELECT * FROM Suppliers WHERE Country IN ('Germany', 'France', 'UK');SELECT * FROM Suppliers WHERE Country = 'Germany' OR Country = 'France' OR Country = 'UK';

The IN operator filters suppliers from 'Germany', 'France', or 'UK'.

Q36

Multiple Choice

Which query retrieves customers with 'CustomerID' in (501, 502, 503)?

SQL Code

SELECT * FROM Customers
WHERE CustomerID IN (501, 502, 503);

SELECT * FROM Customers WHERE CustomerID = 501 OR 502 OR 503; SELECT * FROM Customers WHERE CustomerID LIKE 501 OR 502 OR 503; SELECT * FROM Customers WHERE CustomerID = ANY (501, 502, 503);SELECT * FROM Customers WHERE CustomerID IN (501, 502, 503);

The IN operator filters customers with 'CustomerID' 501, 502, or 503.

Q37

Multiple Choice

How do you select orders where 'OrderDate' is '2023-01-01', '2023-02-01', or '2023-03-01'?

SQL Code

SELECT * FROM Orders
WHERE OrderDate IN ('2023-01-01', '2023-02-01', '2023-03-01');

SELECT * FROM Orders WHERE OrderDate = '2023-01-01' OR '2023-02-01' OR '2023-03-01'; SELECT * FROM Orders WHERE OrderDate IN ('2023-01-01', '2023-02-01', '2023-03-01'); SELECT * FROM Orders WHERE OrderDate = ANY ('2023-01-01', '2023-02-01', '2023-03-01');SELECT * FROM Orders WHERE OrderDate LIKE '2023-01-01' OR '2023-02-01' OR '2023-03-01';

The IN operator filters orders where 'OrderDate' is '2023-01-01', '2023-02-01', or '2023-03-01'.

Q38

Multiple Choice

Which query retrieves products where 'CategoryID' is in (5, 10, 15)?

SQL Code

SELECT * FROM Products
WHERE CategoryID IN (5, 10, 15);

SELECT * FROM Products WHERE CategoryID = 5 OR 10 OR 15; SELECT * FROM Products WHERE CategoryID IN (5, 10, 15); SELECT * FROM Products WHERE CategoryID = ANY (5, 10, 15);SELECT * FROM Products WHERE CategoryID LIKE 5 OR 10 OR 15;

The IN operator filters products where 'CategoryID' is 5, 10, or 15.

Q39

Multiple Choice

How do you find customers from 'Japan', 'Korea', or 'China' using the IN operator?

SQL Code

SELECT * FROM Customers
WHERE Country IN ('Japan', 'Korea', 'China');

SELECT * FROM Customers WHERE Country = 'Japan' AND 'Korea' AND 'China'; SELECT * FROM Customers WHERE Country LIKE 'Japan' OR 'Korea' OR 'China'; SELECT * FROM Customers WHERE Country IN ('Japan', 'Korea', 'China');SELECT * FROM Customers WHERE Country = ANY ('Japan', 'Korea', 'China');

The IN operator filters customers from 'Japan', 'Korea', or 'China'.

Q40

Multiple Choice

Which query retrieves suppliers with 'SupplierID' in (201, 202, 203)?

SQL Code

SELECT * FROM Suppliers
WHERE SupplierID IN (201, 202, 203);

SELECT * FROM Suppliers WHERE SupplierID LIKE 201 OR 202 OR 203; SELECT * FROM Suppliers WHERE SupplierID = ANY (201, 202, 203); SELECT * FROM Suppliers WHERE SupplierID IN (201, 202, 203);SELECT * FROM Suppliers WHERE SupplierID = 201 OR 202 OR 203;

The IN operator filters suppliers with 'SupplierID' 201, 202, or 203.

Q41

Multiple Choice

How do you select employees with 'EmployeeID' in (100, 200, 300)?

SQL Code

SELECT * FROM Employees
WHERE EmployeeID IN (100, 200, 300);

SELECT * FROM Employees WHERE EmployeeID = 100 OR 200 OR 300; SELECT * FROM Employees WHERE EmployeeID IN (100, 200, 300); SELECT * FROM Employees WHERE EmployeeID LIKE 100 OR 200 OR 300;SELECT * FROM Employees WHERE EmployeeID = ANY (100, 200, 300);

The IN operator filters employees with 'EmployeeID' 100, 200, or 300.

Q42

Multiple Choice

Which query finds orders where 'OrderAmount' is in (500, 1000, 1500)?

SQL Code

SELECT * FROM Orders
WHERE OrderAmount IN (500, 1000, 1500);

SELECT * FROM Orders WHERE OrderAmount LIKE 500 OR 1000 OR 1500; SELECT * FROM Orders WHERE OrderAmount = 500 OR 1000 OR 1500; SELECT * FROM Orders WHERE OrderAmount IN (500, 1000, 1500);SELECT * FROM Orders WHERE OrderAmount = ANY (500, 1000, 1500);

The IN operator filters orders where 'OrderAmount' is 500, 1000, or 1500.

Q43

Multiple Choice

How do you retrieve products with 'ProductID' in (110, 120, 130)?

SQL Code

SELECT * FROM Products
WHERE ProductID IN (110, 120, 130);

SELECT * FROM Products WHERE ProductID LIKE 110 OR 120 OR 130; SELECT * FROM Products WHERE ProductID = 110 OR 120 OR 130; SELECT * FROM Products WHERE ProductID = ANY (110, 120, 130);SELECT * FROM Products WHERE ProductID IN (110, 120, 130);

The IN operator filters products where 'ProductID' is 110, 120, or 130.

Q44

Multiple Choice

Which query retrieves employees with 'LastName' in 'Smith', 'Jones', or 'Brown'?

SQL Code

SELECT * FROM Employees
WHERE LastName IN ('Smith', 'Jones', 'Brown');

SELECT * FROM Employees WHERE LastName LIKE 'Smith' OR 'Jones' OR 'Brown'; SELECT * FROM Employees WHERE LastName = 'Smith' AND 'Jones' AND 'Brown'; SELECT * FROM Employees WHERE LastName = ANY ('Smith', 'Jones', 'Brown');SELECT * FROM Employees WHERE LastName IN ('Smith', 'Jones', 'Brown');

The IN operator filters employees with 'LastName' 'Smith', 'Jones', or 'Brown'.

Q45

Multiple Choice

How do you find orders where 'ShippingCity' is 'Los Angeles', 'San Francisco', or 'San Diego'?

SQL Code

SELECT * FROM Orders
WHERE ShippingCity IN ('Los Angeles', 'San Francisco', 'San Diego');

SELECT * FROM Orders WHERE ShippingCity LIKE 'Los Angeles' OR 'San Francisco' OR 'San Diego'; SELECT * FROM Orders WHERE ShippingCity = 'Los Angeles' AND 'San Francisco' AND 'San Diego'; SELECT * FROM Orders WHERE ShippingCity = ANY ('Los Angeles', 'San Francisco', 'San Diego');SELECT * FROM Orders WHERE ShippingCity IN ('Los Angeles', 'San Francisco', 'San Diego');

The IN operator filters orders where 'ShippingCity' is 'Los Angeles', 'San Francisco', or 'San Diego'.

Microsoft SQL Server Database Quiz Questions