In sql

In sql

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

3

In in sql

(IN) operator in sql like "OR" operator
For example: 
Select * From employees
Where department_id "IN" (60,90);

2

In operator sql

SELECT EmpId FROM EmployeeDetails
UNION 
SELECT EmpId FROM EmployeeSalary;

-1

Source: artoftesting.com

In operator sql

SELECT EmpId,
Salary+Variable as TotalSalary 
FROM EmployeeSalary;

-1

Source: artoftesting.com

In operator sql

SELECT FullName
FROM EmployeeDetails
WHERE FullName LIKE ‘__hn%’;

-1

Source: artoftesting.com

In operator in sql

(IN) operator in sql like "OR" operator
For example: 
Select * From employees
Where department_id "IN" (60,90);

-1

Similar codes

0 vote181 views2 answers
Mysql update two tables at once
SQL
0 vote193 views1 answer
How to query all tables mysql at the same time
SQL
0 vote192 views1 answer
Selecting duplicates
SQL
0 vote178 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
0 vote179 views1 answer
How to know if table in rigt or left in sql
SQL
0 vote183 views1 answer
Sql change date format
SQL
-1 vote185 views2 answers
REMOVE DATE FROM DATE TIME SQL SERVER
SQL
0 vote186 views1 answer
What is delimiter in mysql
SQL
0 vote212 views2 answers
How to get max from each department in sql
SQL
17 votes208 views2 answers
Mysql date to string
SQL

Share