How to write not equal to a certain value in Oracle

The syntax in Oracle to indicate that it is not equal to a certain value is "column_name <> value". For example, to query employees whose salary is not equal to $1,000, you can use "SELECT emp_id, salary FROM employees WHERE salary < > 1000;" query.

How to write a value that is not equal to a certain value in Oracle

In Oracle, you can use the "NOT" operator to indicate that it is not equal to a certain value. The specific syntax is as follows:

<code class="SQL">column_name <> value</code>

Among them:

• column_name is the column name to be compared
• value is the column name to be compared Comparative values

Example:

Suppose there is a table named "employees", which contains "emp_id" and "salary" columns. To query for employees whose salary is not equal to $1000, you can use the following query:

<code class="SQL">SELECT emp_id, salary
FROM employees
WHERE salary <> 1000;</code>

This query will return all rows with emp_id and salary columns where the salary column is not equal to $1000.

The above is the detailed content of How to write not equal to a certain value in Oracle. For more information, please follow other related articles on the PHP Chinese website!