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

0 vote155 views1 answer
.sql File Run in PSQL
SQL
0 vote130 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
0 vote131 views1 answer
Mariadb LOAD DATA INFILE
SQL
0 vote204 views1 answer
Mysql update table from select on another table
SQL
0 vote124 views1 answer
Inser into example
SQL
0 vote133 views1 answer
Sql server whoami
SQL
10 votes143 views2 answers
Sql rtrim
SQL
0 vote150 views1 answer
How get data from database if id not found then search another column
SQL
1 vote103 views1 answer
Unique vs distinct sql
SQL
2 votes160 views2 answers
Convert_tz mysql
SQL