How to enter the not equal symbol in sql

The inequality symbol in SQL is "<>", which is used to compare whether two values ​​are unequal and return a Boolean value TRUE or FALSE. It can be used to compare expressions or constants, such as "SELECT * FROM table_name WHERE column_name <> 'value';". This query will select all records where the "column_name" column value is not equal to 'value'.

Input the inequality symbol in SQL

The inequality symbol in SQL is "<>". It is used to compare two values ​​and returns a Boolean value (TRUE or FALSE) indicating whether the two values ​​are not equal.

Using the inequality symbol

You can use the "<>" operator to compare two expressions or constants, as shown below:

<code class="sql">SELECT * FROM table_name WHERE column_name <> 'value';</code>

This query will select all records from the "table_name" table where the value in the "column_name" column is not equal to 'value'.

Example

To find the "value" column value for all rows that are not equal to 10, you can use the following query:

<code class="sql">SELECT value FROM table_name WHERE value <> 10;</code>

This query will return All "value" column values ​​that are not equal to the number 10.

Note:

• The "<>" operator is also called the "not equal to" operator.
• Some database management systems (DBMS) may support additional operators, such as "!=", which has the same functionality as "<>".

The above is the detailed content of How to enter the not equal symbol in sql. For more information, please follow other related articles on the PHP Chinese website!