Tutorialspoint examples

Learn java tutorial with examples for beginners online

SQL SELECT IN Operator

The IN operator is used to reduce the multiple or conditions by specifying the multiple values in a where clause.

Syntax:

SELECT * FROM tableName WHERE columnName IN (value1,value2,… valueN);

The value of the conditioned column should be equal to the any one of the specified values in the IN operator.

Example:

SELECT * FROM EMPLOYEE WHERE EMP_ID IN (1,2,5);

Output:

EMP_ID	EMP_NAME	AGE	SALARY
1	Parbhjot	28	35000
5	Parmender	28	45000
2	Parmender	28	45000

 
Next Topic: SQL NOT IN Operator with example.
Previous Topic: SQL SELECT TOP with example.

Related Topics:

How to build java project using ant in eclipse?
JAXB marshalling – convert java object to xml example.
How to create pdf file in java using iText jar?
Generics class example.
OGNL in struts 2.
Hibernate One-to-One Mapping using xml.
Send inline image in email using JavaMail API.
Quartz 2 JobListener example.

 

Copyright © 2017 Tutorialspoint examples DMCA.com Protection Status