Write down the MySQL query which shows inequality condition?

Inequality means NOT EQUAL TO and MySQL have two inequality operator, ‘<>’ and ‘!=’. following MySQL queries shows the inequality conditions

mysql> Select tender_value From estimated_cost1 WHERE Name_company != 'Chd Ltd.';

The above query shows inequality condition because it have != operator.

mysql> Select tender_value From estimated_cost1 WHERE Name_company <> 'Chd Ltd.';

The above query shows inequality condition because it have <> operator.

Published on 21-Feb-2018 13:52:42