SQL In

The SQL In operator is used to filter records based on a list of values. It’s a convinient way to check if a column value matches any value within a specified list, allowing you to avoid using multiple OR conditions.

Tutorials dojo strip

SQL In Syntax

SQL

SQL In Filter Patients by Gender Example

This query fetches all patients since they all match either ‘M’ or ‘F’ which are the Male and Female gender.

SQL

SQL In Using Subquery with In Example

This query will return all doctors who have at least one scheduled appointment.

SQL

SQL In Find Doctors with Specific Specialties Example

This query will return doctors who practice specific specialties.

SQL

SQL In Visual Diagram

SQL In Labs

Tutorials dojo strip