Scribd
Upload
38 views4 pages

SQL Operators: BETWEEN, LIKE, IN

The document explains the use of SQL operators: BETWEEN, LIKE, and IN. It provides examples for retrieving employees based on salary range, email domain, and department affiliation. The examples demonstrate how to construct SQL queries for each operator effectively.

Uploaded by

itmanarif
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
38 views4 pages

SQL Operators: BETWEEN, LIKE, IN

The document explains the use of SQL operators: BETWEEN, LIKE, and IN. It provides examples for retrieving employees based on salary range, email domain, and department affiliation. The examples demonstrate how to construct SQL queries for each operator effectively.

Uploaded by

itmanarif
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 4

Day – 17 :

Between, Like and In


Operator

Course created by Satish Dhawale | www.skillcourse.in


Between Operators

Retrieve employees whose salary is between 40,000 and 60,000.

SELECT first_name, last_name, salary


FROM employees
WHERE salary BETWEEN 40000 AND 60000;
Find employees whose email addresses end with gmail.com.

LIKE Operator

Find employees whose email addresses end with gmail.com.

SELECT first_name, last_name, email


FROM employees
WHERE email LIKE '%@gmail.com';
Find employees whose email addresses end with gmail.com.

IN Operator

Retrieve employees who belong to either the 'Finance' or


'Marketing' departments.

SELECT first_name, last_name, department


FROM employees
WHERE department IN ('Finance', 'Marketing');

You might also like