Test Your Microsoft SQL Server Not Equal Operators ('<>' or '!=') Knowledge with This Quiz

Progress

True / False

The '<>' operator can be used to find rows where a column value is not equal to a specified value.

True False

The '<>' operator is used to specify that a column's value should not be equal to a given value.

True / False

Using '!=' and '<>' in SQL Server will result in the same output.

True False

In SQL Server, both '!=' and '<>' can be used to specify inequality and they produce the same result.

True / False

The '<>' operator cannot be used with string data types in SQL Server.

True False

The '<>' operator can be used with string data types to compare inequality.

True / False

The '<>' operator is case-sensitive when comparing string values.

True False

The '<>' operator's case sensitivity depends on the collation setting of the SQL Server instance.

True / False

In SQL Server, the '<>' operator can be used to compare NULL values.

True False

In SQL Server, comparing NULL values using the '<>' operator will result in unknown since NULL represents an unknown value.

True / False

Using '<>' in a WHERE clause will filter out rows where the column value is equal to the specified value.

True False

The '<>' operator filters out rows where the column value matches the specified value.

True / False

The '<>' operator can be used in a JOIN condition to exclude matching rows from the result set.

True False

Using '<>' in a JOIN condition will exclude rows where the specified columns are equal, similar to filtering in a WHERE clause.

True / False

The '<>' operator will not work with numeric data types.

True False

The '<>' operator works with numeric data types to compare inequality.

True / False

The '<>' operator can be used in a CASE statement to specify conditions for different outcomes.

True False

The '<>' operator can be used within a CASE statement to specify conditions under which different results are returned.

Q10

True / False

The '<>' operator can be used in an UPDATE statement to modify rows that do not meet a specific condition.

True False

The '<>' operator can be used in the WHERE clause of an UPDATE statement to target rows that do not match a specified condition.

Q11

True / False

When using the '<>' operator in a query, it will not affect the performance of the query.

True False

Using the '<>' operator may impact query performance, especially if the column is not indexed appropriately.

Q12

True / False

In a query with multiple conditions, using '<>' with AND will return rows that satisfy all conditions.

True False

Using '<>' with AND in a WHERE clause will return rows that meet all specified conditions, where each condition uses the '<>' operator to exclude specific values.

Q13

True / False

The '<>' operator cannot be used in combination with other operators like 'AND' or 'OR' in a WHERE clause.

True False

The '<>' operator can be combined with 'AND' or 'OR' to form complex conditions in a WHERE clause.

Q14

True / False

Using the '<>' operator will return rows with NULL values in the specified column.

True False

Using '<>' in a WHERE clause will not return rows where the column value is NULL, because NULL represents an unknown value.

Q15

True / False

In SQL Server, '<>' and '!=' are completely interchangeable.

True False

In SQL Server, '<>' and '!=' are interchangeable and both can be used to compare inequality.

Q16

Single Choice

Which of the following queries will correctly select rows where the column 'Age' is not equal to 30?

SQL Code

SELECT * FROM Employees
WHERE Age <> 30;

SELECT * FROM Employees WHERE Age = 30; SELECT * FROM Employees WHERE Age != 30; SELECT * FROM Employees WHERE Age IS NOT 30;SELECT * FROM Employees WHERE Age <> 30;

The query selects rows from the Employees table where the Age column is not equal to 30.

Q17

Single Choice

Which of the following will return rows where the column 'Salary' is not equal to 50000?

SQL Code

SELECT * FROM Employees
WHERE Salary != 50000;

SELECT * FROM Employees WHERE Salary = 50000; SELECT * FROM Employees WHERE Salary != 50000; SELECT * FROM Employees WHERE Salary IS 50000;SELECT * FROM Employees WHERE Salary < 50000;

The query retrieves rows from the Employees table where the Salary column is not equal to 50000.

Q18

Single Choice

Which of these statements correctly selects rows where 'Department' is not equal to 'HR'?

SQL Code

SELECT * FROM Employees
WHERE Department <> 'HR';

SELECT * FROM Employees WHERE Department = 'HR'; SELECT * FROM Employees WHERE Department != 'HR'; SELECT * FROM Employees WHERE Department IS 'HR';SELECT * FROM Employees WHERE Department <> 'HR';

The query retrieves rows where the Department column is not equal to 'HR'.

Q19

Single Choice

How would you exclude rows where 'Status' is 'Active'?

SQL Code

SELECT * FROM Orders
WHERE Status <> 'Active';

SELECT * FROM Orders WHERE Status = 'Active'; SELECT * FROM Orders WHERE Status != 'Active'; SELECT * FROM Orders WHERE Status IS NOT 'Active';SELECT * FROM Orders WHERE Status <> 'Active';

The query selects rows from the Orders table where the Status column is not 'Active'.

Q20

Single Choice

Which query retrieves records where 'Position' is not 'Manager'?

SQL Code

SELECT * FROM Staff
WHERE Position != 'Manager';

SELECT * FROM Staff WHERE Position = 'Manager'; SELECT * FROM Staff WHERE Position != 'Manager'; SELECT * FROM Staff WHERE Position IS 'Manager';SELECT * FROM Staff WHERE Position <> 'Manager';

The query retrieves rows where the Position column does not contain 'Manager'.

Q21

Single Choice

How would you exclude rows where the 'Category' is 'Electronics'?

SQL Code

SELECT * FROM Products
WHERE Category <> 'Electronics';

SELECT * FROM Products WHERE Category = 'Electronics'; SELECT * FROM Products WHERE Category != 'Electronics'; SELECT * FROM Products WHERE Category IS 'Electronics';SELECT * FROM Products WHERE Category <> 'Electronics';

The query retrieves rows from the Products table where the Category column is not 'Electronics'.

Q22

Single Choice

Which of these queries retrieves rows where 'Experience' is not equal to 5 years?

SQL Code

SELECT * FROM Candidates
WHERE Experience != 5;

SELECT * FROM Candidates WHERE Experience = 5; SELECT * FROM Candidates WHERE Experience != 5; SELECT * FROM Candidates WHERE Experience IS NOT 5;SELECT * FROM Candidates WHERE Experience <> 5;

The query retrieves rows from the Candidates table where the Experience column is not equal to 5 years.

Q23

Single Choice

Which statement will select rows where 'ProjectStatus' is not 'Completed'?

SQL Code

SELECT * FROM Projects
WHERE ProjectStatus <> 'Completed';

SELECT * FROM Projects WHERE ProjectStatus = 'Completed'; SELECT * FROM Projects WHERE ProjectStatus != 'Completed'; SELECT * FROM Projects WHERE ProjectStatus IS 'Completed';SELECT * FROM Projects WHERE ProjectStatus <> 'Completed';

The query retrieves rows where the ProjectStatus column is not 'Completed'.

Q24

Single Choice

How do you select rows where 'OrderAmount' is not equal to 1000?

SQL Code

SELECT * FROM Sales
WHERE OrderAmount <> 1000;

SELECT * FROM Sales WHERE OrderAmount = 1000; SELECT * FROM Sales WHERE OrderAmount != 1000; SELECT * FROM Sales WHERE OrderAmount IS NOT 1000;SELECT * FROM Sales WHERE OrderAmount <> 1000;

The query selects rows from the Sales table where the OrderAmount column is not equal to 1000.

Q25

Single Choice

Which query retrieves rows where 'SkillLevel' is not equal to 'Expert'?

SQL Code

SELECT * FROM Skills
WHERE SkillLevel != 'Expert';

SELECT * FROM Skills WHERE SkillLevel = 'Expert'; SELECT * FROM Skills WHERE SkillLevel != 'Expert'; SELECT * FROM Skills WHERE SkillLevel IS NOT 'Expert';SELECT * FROM Skills WHERE SkillLevel <> 'Expert';

The query retrieves rows from the Skills table where the SkillLevel column is not equal to 'Expert'.

Q26

Single Choice

How would you write a query to exclude rows where 'Region' is 'North America'?

SQL Code

SELECT * FROM Regions
WHERE Region <> 'North America';

SELECT * FROM Regions WHERE Region = 'North America'; SELECT * FROM Regions WHERE Region != 'North America'; SELECT * FROM Regions WHERE Region IS NOT 'North America';SELECT * FROM Regions WHERE Region <> 'North America';

The query retrieves rows from the Regions table where the Region column is not 'North America'.

Q27

Single Choice

Which query will select rows where 'ProductID' is not equal to 100?

SQL Code

SELECT * FROM Products
WHERE ProductID <> 100;

SELECT * FROM Products WHERE ProductID = 100; SELECT * FROM Products WHERE ProductID != 100; SELECT * FROM Products WHERE ProductID IS 100;SELECT * FROM Products WHERE ProductID <> 100;

The query retrieves rows from the Products table where the ProductID column is not equal to 100.

Q28

Single Choice

How would you write a query to exclude rows where 'VendorName' is 'Acme Corp'?

SQL Code

SELECT * FROM Vendors
WHERE VendorName <> 'Acme Corp';

SELECT * FROM Vendors WHERE VendorName = 'Acme Corp'; SELECT * FROM Vendors WHERE VendorName != 'Acme Corp'; SELECT * FROM Vendors WHERE VendorName IS NOT 'Acme Corp';SELECT * FROM Vendors WHERE VendorName <> 'Acme Corp';

The query selects rows from the Vendors table where the VendorName column is not 'Acme Corp'.

Q29

Single Choice

Which query retrieves rows where 'Discount' is not equal to 0?

SQL Code

SELECT * FROM Sales
WHERE Discount <> 0;

SELECT * FROM Sales WHERE Discount = 0; SELECT * FROM Sales WHERE Discount != 0; SELECT * FROM Sales WHERE Discount IS NOT 0;SELECT * FROM Sales WHERE Discount <> 0;

The query retrieves rows from the Sales table where the Discount column is not equal to 0.

Q30

Single Choice

How do you write a query to exclude rows where 'OrderStatus' is 'Shipped'?

SQL Code

SELECT * FROM Orders
WHERE OrderStatus <> 'Shipped';

SELECT * FROM Orders WHERE OrderStatus = 'Shipped'; SELECT * FROM Orders WHERE OrderStatus != 'Shipped'; SELECT * FROM Orders WHERE OrderStatus IS NOT 'Shipped';SELECT * FROM Orders WHERE OrderStatus <> 'Shipped';

The query selects rows from the Orders table where the OrderStatus column is not 'Shipped'.

Q31

Multiple Choice

Which of the following queries correctly select rows where 'ProductName' is not equal to 'Gadget'?

SQL Code

SELECT * FROM Inventory
WHERE ProductName <> 'Gadget';

SELECT * FROM Inventory WHERE ProductName = 'Gadget'; SELECT * FROM Inventory WHERE ProductName != 'Gadget'; SELECT * FROM Inventory WHERE ProductName <> 'Gadget';SELECT * FROM Inventory WHERE ProductName IS NOT 'Gadget';

The queries select rows from the Inventory table where the ProductName column is not 'Gadget'.

Q32

Multiple Choice

Which of the following will retrieve rows where 'Year' is not equal to 2021?

SQL Code

SELECT * FROM Events
WHERE Year <> 2021;

SELECT * FROM Events WHERE Year = 2021; SELECT * FROM Events WHERE Year != 2021; SELECT * FROM Events WHERE Year <> 2021;SELECT * FROM Events WHERE Year IS NOT 2021;

The queries retrieve rows from the Events table where the Year column is not equal to 2021.

Q33

Multiple Choice

How would you select rows where 'Price' is not equal to 100?

SQL Code

SELECT * FROM Products
WHERE Price <> 100;

SELECT * FROM Products WHERE Price = 100; SELECT * FROM Products WHERE Price != 100; SELECT * FROM Products WHERE Price <> 100;SELECT * FROM Products WHERE Price IS NOT 100;

The queries retrieve rows from the Products table where the Price column is not equal to 100.

Q34

Multiple Choice

Which statements will exclude rows where 'JobTitle' is 'Analyst'?

SQL Code

SELECT * FROM Employees
WHERE JobTitle <> 'Analyst';

SELECT * FROM Employees WHERE JobTitle = 'Analyst'; SELECT * FROM Employees WHERE JobTitle != 'Analyst'; SELECT * FROM Employees WHERE JobTitle <> 'Analyst';SELECT * FROM Employees WHERE JobTitle IS NOT 'Analyst';

The queries retrieve rows from the Employees table where the JobTitle column is not 'Analyst'.

Q35

Multiple Choice

Which of these queries will correctly select rows where 'Rating' is not 5?

SQL Code

SELECT * FROM Reviews
WHERE Rating <> 5;

SELECT * FROM Reviews WHERE Rating = 5; SELECT * FROM Reviews WHERE Rating != 5; SELECT * FROM Reviews WHERE Rating <> 5;SELECT * FROM Reviews WHERE Rating IS NOT 5;

The queries retrieve rows from the Reviews table where the Rating column is not equal to 5.

Q36

Multiple Choice

How would you write a query to exclude rows where 'Availability' is 'In Stock'?

SQL Code

SELECT * FROM Inventory
WHERE Availability <> 'In Stock';

SELECT * FROM Inventory WHERE Availability = 'In Stock'; SELECT * FROM Inventory WHERE Availability != 'In Stock'; SELECT * FROM Inventory WHERE Availability <> 'In Stock';SELECT * FROM Inventory WHERE Availability IS NOT 'In Stock';

The queries retrieve rows from the Inventory table where the Availability column is not 'In Stock'.

Q37

Multiple Choice

Which of the following will exclude rows where 'Budget' is 5000?

SQL Code

SELECT * FROM Projects
WHERE Budget <> 5000;

SELECT * FROM Projects WHERE Budget = 5000; SELECT * FROM Projects WHERE Budget != 5000; SELECT * FROM Projects WHERE Budget <> 5000;SELECT * FROM Projects WHERE Budget IS NOT 5000;

The queries retrieve rows from the Projects table where the Budget column is not equal to 5000.

Q38

Multiple Choice

Which of the following queries will retrieve rows where 'Location' is not 'New York'?

SQL Code

SELECT * FROM Offices
WHERE Location <> 'New York';

SELECT * FROM Offices WHERE Location = 'New York'; SELECT * FROM Offices WHERE Location != 'New York'; SELECT * FROM Offices WHERE Location <> 'New York';SELECT * FROM Offices WHERE Location IS NOT 'New York';

The queries retrieve rows from the Offices table where the Location column is not 'New York'.

Q39

Multiple Choice

Which queries will select rows where 'EmployeeStatus' is not 'Active'?

SQL Code

SELECT * FROM EmployeeStatus
WHERE EmployeeStatus <> 'Active';

SELECT * FROM EmployeeStatus WHERE EmployeeStatus = 'Active'; SELECT * FROM EmployeeStatus WHERE EmployeeStatus != 'Active'; SELECT * FROM EmployeeStatus WHERE EmployeeStatus <> 'Active';SELECT * FROM EmployeeStatus WHERE EmployeeStatus IS NOT 'Active';

The queries retrieve rows from the EmployeeStatus table where the EmployeeStatus column is not 'Active'.

Q40

Multiple Choice

How would you write a query to select rows where 'TransactionType' is not 'Credit'?

SQL Code

SELECT * FROM Transactions
WHERE TransactionType <> 'Credit';

SELECT * FROM Transactions WHERE TransactionType = 'Credit'; SELECT * FROM Transactions WHERE TransactionType != 'Credit'; SELECT * FROM Transactions WHERE TransactionType <> 'Credit';SELECT * FROM Transactions WHERE TransactionType IS NOT 'Credit';

The queries retrieve rows from the Transactions table where the TransactionType column is not 'Credit'.

Q41

Multiple Choice

Which of the following queries will correctly select rows where 'Grade' is not equal to 'A'?

SQL Code

SELECT * FROM Students
WHERE Grade <> 'A';

SELECT * FROM Students WHERE Grade = 'A'; SELECT * FROM Students WHERE Grade != 'A'; SELECT * FROM Students WHERE Grade <> 'A';SELECT * FROM Students WHERE Grade IS NOT 'A';

The queries retrieve rows from the Students table where the Grade column is not equal to 'A'.

Q42

Multiple Choice

How would you write a query to exclude rows where 'PublicationYear' is 2020?

SQL Code

SELECT * FROM Books
WHERE PublicationYear <> 2020;

SELECT * FROM Books WHERE PublicationYear = 2020; SELECT * FROM Books WHERE PublicationYear != 2020; SELECT * FROM Books WHERE PublicationYear <> 2020;SELECT * FROM Books WHERE PublicationYear IS NOT 2020;

The queries retrieve rows from the Books table where the PublicationYear column is not equal to 2020.

Q43

Multiple Choice

Which of the following queries will retrieve rows where 'DeliveryStatus' is not 'Delivered'?

SQL Code

SELECT * FROM Deliveries
WHERE DeliveryStatus <> 'Delivered';

SELECT * FROM Deliveries WHERE DeliveryStatus = 'Delivered'; SELECT * FROM Deliveries WHERE DeliveryStatus != 'Delivered'; SELECT * FROM Deliveries WHERE DeliveryStatus <> 'Delivered';SELECT * FROM Deliveries WHERE DeliveryStatus IS NOT 'Delivered';

The queries retrieve rows from the Deliveries table where the DeliveryStatus column is not 'Delivered'.

Q44

Multiple Choice

How do you write a query to exclude rows where 'Branch' is 'Downtown'?

SQL Code

SELECT * FROM Branches
WHERE Branch <> 'Downtown';

SELECT * FROM Branches WHERE Branch = 'Downtown'; SELECT * FROM Branches WHERE Branch != 'Downtown'; SELECT * FROM Branches WHERE Branch <> 'Downtown';SELECT * FROM Branches WHERE Branch IS NOT 'Downtown';

The queries retrieve rows from the Branches table where the Branch column is not 'Downtown'.

Q45

Multiple Choice

Which of the following queries will select rows where 'CustomerID' is not 101?

SQL Code

SELECT * FROM Customers
WHERE CustomerID <> 101;

SELECT * FROM Customers WHERE CustomerID = 101; SELECT * FROM Customers WHERE CustomerID != 101; SELECT * FROM Customers WHERE CustomerID <> 101;SELECT * FROM Customers WHERE CustomerID IS NOT 101;

The queries retrieve rows from the Customers table where the CustomerID column is not equal to 101.

Microsoft SQL Server Database Quiz Questions