Home » SQL

IN Operator with Example in SQL

In this article, we are going to discuss about use of IN Operator in SQL statement.
Submitted by Bharti Parmar, on December 30, 2018

When you have multiple conditions to be checked, we can use IN operator instead of it. It specifies the multiple values in a WHERE clause.

Syntax:

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

Example:

Table 1:

customer_IDcustomer_NameAddresscityCountry
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

Query to find customer_name and address where city is bihar

IN Operator

Conclusion:

In this article, we have learnt how to use IN Operator? I hope you understand the concept; if you have any query, feel free to ask in the comment section.





Comments and Discussions

Ad: Are you a blogger? Join our Blogging forum.



Languages: » C » C++ » C++ STL » Java » Data Structure » C#.Net » Android » Kotlin » SQL
Web Technologies: » PHP » Python » JavaScript » CSS » Ajax » Node.js » Web programming/HTML
Solved programs: » C » C++ » DS » Java » C#
Aptitude que. & ans.: » C » C++ » Java » DBMS
Interview que. & ans.: » C » Embedded C » Java » SEO » HR
CS Subjects: » CS Basics » O.S. » Networks » DBMS » Embedded Systems » Cloud Computing » Machine learning » CS Organizations » Linux » DOS
More: » Articles » Puzzles » News/Updates

© https://www.includehelp.com some rights reserved.