IN Operator with Example in SQL

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.

DURGESH

I Love python, so I like machine learning a Lot and on the other hand, I like building apps and fun games I post blogs on my website for Tech enthusiast to learn and Share Information With The World.

Leave a Reply

Your email address will not be published. Required fields are marked *

three × five =

Recent Content