Used alongside a WHERE clause as a shorthand for multiple OR conditions.
So instead of:
SELECT * FROM users
WHERE country = 'USA' OR country = 'United Kingdom' OR
country = 'Russia' OR country = 'Australia';
You can use:
SELECT * FROM users
WHERE country IN ('USA', 'United Kingdom', 'Russia',
'Australia');
(IN) operator in sql like "OR" operator
For example:
Select * From employees
Where department_id "IN" (60,90);
SELECT first_name, country
FROM Customers
WHERE country IN ('USA', 'UK');
SELECT FullName
FROM EmployeeDetails
WHERE FullName LIKE ‘__hn%’;
SELECT EmpId,
Salary+Variable as TotalSalary
FROM EmployeeSalary;
SELECT EmpId FROM EmployeeDetails
UNION
SELECT EmpId FROM EmployeeSalary;
(IN) operator in sql like "OR" operator
For example:
Select * From employees
Where department_id "IN" (60,90);
Code Example |
---|
Sql :: sql query order |
Sql :: memberikan password root mysql |
Sql :: sqlplus change user |
Sql :: sql contains vs like |
Sql :: replace sql |
Sql :: mysql update from n to 100 |
Sql :: mssql default connection string |
Sql :: bigquery information_schema schema all columns |
Sql :: how to login to mysql as normal user in ubuntu |
Sql :: sqlcmd list tables |
Sql :: mysql varchar length |
Sql :: check constraint in ms sql |
Sql :: row number sql |
Sql :: create column that already exists mysql |
Sql :: local sql server |
Sql :: what is top n result in sql |
Sql :: what is between keyword used for |
Sql :: drop a field in psql django |
Sql :: sql date between one week |
Sql :: query only first letter string |
Sql :: delete sql |
Sql :: create user in mysql |
Sql :: sql query for displaying age from oldest to youngest |
Sql :: group by |
Sql :: not in in mongodb |
Sql :: mysql run file command |
Sql :: delete join sql server |
Sql :: sql selet |
Sql :: Example SQL Test |
Sql :: select where sql |