bugl
bugl
HomeLearnPatternsPathsSearch
HomeLearnPatternsPathsSearch

Loading lesson path

Learn/SQL/SQL References
SQL•SQL References

SQL NOT Keyword

Flash cards

Review the key moves

1/4
Core idea

What is the main idea behind SQL NOT Keyword?

Lesson checks

Practice each idea before moving on

Short Mimo-style checks built from this lesson's code, terms, and sequence.

1Quick choice

Which statement best captures the main point of this lesson?

2Fill blank

Complete the missing token from the example code.

___ * FROM Customers

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';

Previous

SQL SELECT TOP, LIMIT and ROWNUM Keywords

Next

SQL NOT NULL Keyword