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.

Chandu yadav

Published on 21-Feb-2018 09:22:42

• Related Questions & Answers
• Write down the MySQL query which shows equality condition?
• MySQL Sum Query with IF Condition?
• MySQL Sum Query with IF Condition using Stored Procedure
• Write a single MySQL query to return the ID from the corresponding row which is a NOT NULL value
• MySQL query to return only the rows which are numeric?
• MySQL query to update different fields based on a condition?
• Which MySQL query can be used with the help of which we can see the list of MySQL databases?
• How to use count with CASE condition in a MySQL query?
• Count index pairs which satisfy the given condition in C++
• TV Shows in C++
• Find the lexicographically smallest string which satisfies the given condition in Python
• MySQL query to get result by month and year based on condition?
• Perform SUM and SUBTRACTION on the basis of a condition in a single MySQL query?
• Correctly implement the AND condition in MySQL
• Condition Variables within Sub-Query in SAP