SQL Special Operators

IN Operator

• • • It  is a logical operator
    • It allows to test whether a specified value matches any value in a list
    • The IN returns 1 when the search value present within the range otherwise returns 0.

List all Employee who have Department name is either Finance or IT.

SELECT EmployeeID, Employee_FirstName,Employee_LastName
FROM Employee
WHERE DepartmentName = ‘Finance’
OR DepartmentName = ‘IT’;

OR

SELECT EmployeeID, Employee_FirstName,Employee_LastName
FROM Employee
WHERE DepartmentName IN (‘Finance’, ‘IT’);

LIKE Operator

• • • It  is a logical operator
    • It is used to  search for a specified pattern in a column.
    • The LIKE operator is used in the Where clause of the Select , Update and Delete.

List all Employee who have Department name  begins with a ‘F’ and has ‘I’ as the second character

SELECT EmployeeID, Employee_FirstName,Employee_LastName
FROM Employee
WHERE DepartmentName  LIKE ‘Fi%’;

List all Employee who have Department name  has ‘T’ as the second character.

SELECT EmployeeID, Employee_FirstName,Employee_LastName
FROM Employee
WHERE DepartmentName LIKE ‘_t%’;

SQL – BETWEEN

• • • It  is a logical operator
    • This operator is used to select values within a given range.

List all Employee who have salary in the range INR 10000 to  INR 20000

SELECT EmployeeID, Employee_FirstName,Employee_LastName
FROM Employee
WHERE Salary >= 10000
AND Salary <= 20000;

OR

SELECT EmployeeID, Employee_FirstName,Employee_LastName
FROM Employee
WHERE Salary
BETWEEN 10000 AND 20000;

Recommended Articles:

• • • SQL Sorting (Order By)
    • SQL Group By
    • SQL Aggregate Function
    • SQL Having