Uncategorized

Database: Query Builder – Where Not Clauses

Roshan K

In SQL, the WHERE NOT clause is used to filter rows from a result set based on a condition that should not be met. It is a logical operator that negates the condition specified in the WHERE clause. The WHERE NOT clause is typically used in conjunction with other comparison operators or logical operators to perform more complex filtering in SQL queries.

Syntax:

The syntax for using the WHERE NOT clause in SQL is as follows:

SELECT column1, column2, ...
FROM table
WHERE NOT condition;
  • SELECT: Specifies the columns to be included in the result set.
  • FROM: Specifies the table from which to retrieve data.
  • WHERE: Specifies the condition that must be met for a row to be included in the result set.
  • NOT: Negates the condition specified in the WHERE clause.

Example:

Let’s assume we have a table named “employees” with columns such as “employee_id”, “first_name”, and “salary”. If we want to select all employees whose salary is not greater than 5000, we can use the WHERE NOT clause as follows:

SELECT employee_id, first_name, salary
FROM employees
WHERE NOT salary > 5000;

This query will return all the rows from the “employees” table where the salary is not greater than 5000.

The WHERE NOT clause can be combined with other operators such as “=”, “<>”, “<“, “>”, “<=”, “>=”, and logical operators such as AND, OR to create more complex conditions for filtering data in SQL queries.

It’s important to carefully construct the condition and consider the logical implications when using the WHERE NOT clause to ensure the desired results are obtained.

Related Posts