in operator in sql

1=	Checks if the values of two operands are equal or not, if yes then condition becomes true.	(a = b) is not true.
2!=	Checks if the values of two operands are equal or not, if values are not equal then condition becomes true.	(a != b) is true.
3<>	Checks if the values of two operands are equal or not, if values are not equal then condition becomes true.	(a <> b) is true.
4>	Checks if the value of left operand is greater than the value of right operand, if yes then condition becomes true.	(a > b) is not true.
5<	Checks if the value of left operand is less than the value of right operand, if yes then condition becomes true.	(a < b) is true.
6>=	Checks if the value of left operand is greater than or equal to the value of right operand, if yes then condition becomes true.	(a >= b) is not true.
7<=	Checks if the value of left operand is less than or equal to the value of right operand, if yes then condition becomes true.	(a <= b) is true.
8!<	Checks if the value of left operand is not less than the value of right operand, if yes then condition becomes true.	(a !< b) is false.
9!>	Checks if the value of left operand is not greater than the value of right operand, if yes then condition becomes true.	(a !> b) is true.

1
2(IN) operator in sql like "OR" operator
3For example: 
4Select * From employees
5Where department_id "IN" (60,90); 
6

1SQL NOT IN operator is used to filter the result if the values that are mentioned as part of the IN operator is not satisfied. Let’s discuss in detail about SQL NOT IN operator.
2
3Syntax:
4SELECT Column(s) FROM table_name WHERE Column NOT IN (value1, value2... valueN);

1(NOT) operator excluding given
2For example:
3Select last_name, job_id From Employees
4Where "Not" job_id = 'ABC';

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

1SELECT EmpId FROM EmployeeDetails
2UNION 
3SELECT EmpId FROM EmployeeSalary;
4