Operator in sql

=	Checks if the values of two operands are equal or not, if yes then condition becomes true.	(a = b) is not true.
!=	Checks if the values of two operands are equal or not, if values are not equal then condition becomes true.	(a != b) is true.
<>	Checks if the values of two operands are equal or not, if values are not equal then condition becomes true.	(a <> b) is true.
>	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.
<	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.
>=	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.
<=	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.
!<	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.
!>	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.

Source: tutorialspoint.com

In operator sql

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

-1

Source: artoftesting.com

In operator sql

SELECT EmpId,
Salary+Variable as TotalSalary 
FROM EmployeeSalary;

-1

Source: artoftesting.com

In operator sql

SELECT EmpId FROM EmployeeDetails
UNION 
SELECT EmpId FROM EmployeeSalary;

-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

1 vote192 views4 answers
Psql: error: FATAL: database "odoo" does not exist
SQL
0 vote205 views1 answer
Frename oracle
SQL
1 vote192 views1 answer
Sql week commencing date
SQL
2 votes184 views2 answers
Created at and updated at in mysql
SQL
4 votes182 views1 answer
Psql get sequences
SQL
1 vote184 views1 answer
How to change owner in postgres
SQL
8 votes240 views1 answer
Database backup in mysql server recovery
SQL
40 votes256 views6 answers
Update table mysql
SQL
1 vote209 views1 answer
Psql human readable
SQL
0 vote203 views1 answer
Sql decode
SQL