in operator 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.

1Used alongside a WHERE clause as a shorthand for multiple OR conditions.
2So instead of:
3SELECT * FROM users
4WHERE country = 'USA' OR country = 'United Kingdom' OR
5country = 'Russia' OR country = 'Australia';
6You can use:
7SELECT * FROM users
8WHERE country IN ('USA', 'United Kingdom', 'Russia',
9'Australia');

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

1SELECT FullName
2FROM EmployeeDetails
3WHERE FullName LIKE ‘__hn%’;
4

1SELECT EmpId,
2Salary+Variable as TotalSalary 
3FROM EmployeeSalary;
4

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