By 25/02/2016 11 Comments

What Is NOT Condition In SQL?

  • The NOT condition is used with LIKE, BETWEEN and IN operators.
  • The NOT condition returns results in negative.

Syntax:

SELECT column_name(s)
FROM table_name
WHERE column_name NOT IN (value1,value2,value3,...);

Example-1: NOT condition with IN operator

SELECT *
FROM products
WHERE p_name NOT IN('laptop','iron');

Example-2: NOT condition with BETWEEN operator

SELECT *
FROM products
WHERE price NOT BETWEEN 700 AND 1501;

Example-3: NOT condition with LIKE operator

SELECT *
FROM products
WHERE p_name NOT LIKE '%p';






← Previous Tutorial


Posted in: Sql

Leave your valuable Comment

Have a natural attraction for women cosmetics and replica watches uk clothes, no
more than two for men the most attractive one, is to make their own driving experience, happy and can serve as the facade of the car, another is to highlight the taste edify sentiment rolex replica watch. The replica rolex is undoubtedly the most fashionable accessories, wear a suit to attend the activities, but also get a decent match on the replica watches .