Syntax error Write down the MySQL query which shows inequality condition?

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.

Updated on: 2020-02-12T07:09:16+05:30

126 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements