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_ID | customer_Name | Address | city | Country |
---|---|---|---|---|
3 | Aman Gautam | Roxy | Gwalior | India |
2 | Atul Anand | Vinay nagar | Gwalior | India |
1 | Bharti Parmar | Sapta | Bihar | India |
4 | Partha Biswas | Tripura | West bengal | India |
Question to discover customer_name and address where city is bihar
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”