SQL•SQL References

SQL NOT Keyword

Concept visual

SQL NOT Keyword

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

NOT Keyword

Not

The NOT

command is used with WHERE to only include rows where a condition is not true. The following SQL statement selects all fields from "Customers" where country is NOT "Germany":

Example

SELECT * FROM Customers

Where

NOT Country='Germany';

SQL NOT Keyword

Concept visual

SQL NOT Keyword

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

NOT Keyword

Not

The NOT

command is used with WHERE to only include rows where a condition is not true. The following SQL statement selects all fields from "Customers" where country is NOT "Germany":

Example

SELECT * FROM Customers

Where

NOT Country='Germany';

SQL NOT Keyword

SQL NOT Keyword

NOT Keyword

Previous

Next

Not

The NOT

Example

Where

Previous

Next

SQL NOT Keyword

SQL NOT Keyword

NOT Keyword

Previous

Next

Not

The NOT

Example

Where

Previous

Next