Which is the comparison operator in SQL?

 In the context of SQL, the option that is correct regarding the comparison operator is option 4 which refers to the =. It is commonly used for the comparison of the given values. Here is the example given of it:-

SELECT *

FROM table_name

WHERE column_name = ‘desired_value’;

The first option which refers to the:= is not used as a comparison operator in SQL, it is mainly used for assignment in some SQL dialects like MySQL. Here is the example given of it:-

  SET @variable_name := ‘some_value’;

SELECT *

FROM table_name

WHERE column_name = @variable_name;

The second option which refers to the > < is>

SELECT *

FROM table_name

WHERE column_name <> ‘undesired_value’;

The third option which refers to the >= is also not a valid comparison operator in the context of the SQL database. It can be used to define greater than or equal to. Here is the example given of it:-

SELECT *

FROM table_name

WHERE column_name >= some_value;