Relational operators analyse two explanations and gives back the outcome in the form of boolean operation.

Operator	Description	Example
=	Analyse whether the two values are True or False, if true, then the case will be true.	A=B
<	Check whether the left esteem is not exactly the right esteem, assuming genuine, then the case turns out to be valid.	A<B
>	Examine whether the left esteem is more prominent than the right esteem, assuming genuine, then the case will be valid.	A>B
<=	Examine whether the left esteem is not exactly or equivalent to the right esteem, if yes, then the case turns out to be valid.	A<=B
>=	Investigate whether the left esteem is more noteworthy than or equivalent to the right esteem, assuming genuine, then the case turns out to be valid.	A>=B

By viewing the below example, the concept of Where Clause can be easily understood. [sql] sql> select * from employee; +--------+-------+-------+ | emp_id | ename | sal | +--------+-------+-------+ | 1001 | mike | 12000 | | 1002 | rambo | 13000 | +--------+-------+-------+ 2 rows in set (0.00 sec) sql> select * from employee where ename='rambo'; +--------+-------+-------+ | emp_id | ename | sal | +--------+-------+-------+ | 1002 | rambo | 13000 | +--------+-------+-------+ 1 row in set (0.00 sec) sql> select * from employee where sal=12000; +--------+-------+-------+ | emp_id | ename | sal | +--------+-------+-------+ | 1001 | mike | 12000 | +--------+-------+-------+ 1 row in set (0.00 sec) [/sql] The above example tells that, when SQL Where Clause operation is performed on a column name like rambo, then it automatically displays the entire details of rambo like emp_id and salary.And then in another query where clause is performed on column name like salary,then it automatically displays the entire details of that employee like emp_id,ename and salary.