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 vote291 views2 answers
Call to undefined function mysql_query()
SQL
3 votes276 views3 answers
Create a view postgres
SQL
1 vote272 views1 answer
Delete specific row in sql
SQL
0 vote298 views1 answer
The fetch keyword oracle
SQL
4 votes293 views1 answer
Postgresql list sequences
SQL
0 vote281 views1 answer
Oracle query to find schema you are working on
SQL
-1 vote286 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
-1 vote268 views1 answer
Mysql select all columns and specific fields as
SQL
0 vote276 views2 answers
How to login to mysql as normal user in ubuntu
SQL
0 vote291 views1 answer
Procedure excute monthly oracle
SQL

Share