IN Operator with Example in SQL

In this article, we will talk about utilization of IN Operator in SQL articulation.

At the point when you have different conditions to be checked, we can use IN administrator rather than it. It determines the different values in a WHERE statement.

Syntax:

SELECT column_name FROM table_name WHERE column_name IN (value1… valueN);

Example:

customer_IDcustomer_NameAddresscityCountry
3Aman GautamRoxyGwaliorIndia
2Atul AnandVinay nagarGwaliorIndia
1Bharti ParmarSaptaBiharIndia
4Partha BiswasTripuraWest bengalIndia

Question to discover customer_name and address where city is bihar

IN Operator with Example in SQL

In this article, we have figured out how to use IN Operator? I trust you comprehend the idea; on the off chance that you have any inquiry, don’t hesitate to ask in the remark segment.

1 thought on “IN Operator with Example in SQL”

Leave a Comment

error: Alert: Content is protected!!