codingtcher.com
Theme Night
Home
Login

Sql In

Home » Sql » Sql In

in operator sql

SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1, value2, ...);

SQL IN Operator

SELECT first_name, country
FROM Customers
WHERE country IN ('USA', 'UK');

in sql

SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1, value2, ...); 

in operator sql

SELECT EmpId FROM EmployeeDetails
UNION 
SELECT EmpId FROM EmployeeSalary;

in operator sql

SELECT EmpId,
Salary+Variable as TotalSalary 
FROM EmployeeSalary;

in query in sql

SELECT Id, CompanyName, City, Country
  FROM Supplier
 WHERE Country IN ('USA', 'UK', 'Japan')
Source: www.dofactory.com

Sql Related Post