Tag: Use of SQL IN Operator

Use of IN operator in SQL

Use of IN operator in SQL: (1) “IN” operator is used where multiple conditions are executed. It is a shortcut of the “OR” operator. It is used with the “WHERE” clause. (2) Syntax of “IN” statement is: SELECT column1, column2, …FROM table_nameWHERE column1 IN (value1,value2… valueN); (3) Let’s take an example to get records according to the “Country …