[go: up one dir, main page]

0% found this document useful (0 votes)
44 views17 pages

05 Filtering Data

The document provides an overview of SQL filtering data using WHERE conditions, detailing various operators including comparison, logical, range, membership, and search operators. It explains the functionality of each operator, such as checking equality, logical conjunctions, and pattern matching. The content is structured to aid in understanding how to effectively filter data in SQL queries.
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
44 views17 pages

05 Filtering Data

The document provides an overview of SQL filtering data using WHERE conditions, detailing various operators including comparison, logical, range, membership, and search operators. It explains the functionality of each operator, such as checking equality, logical conjunctions, and pattern matching. The content is structured to aid in understanding how to effectively filter data in SQL queries.
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 17

Filtering Data

WHERE CONDITIONS

Baraa Khatib Salkini


YouTube | DATA WITH BARAA
SQL Course | FILTERING DATA
WHERE
operators

Comparison Logical Range Membership Search


Operators Operators Operator Operator Operator

= AND BETWEEN IN LIKE


<> =! OR NOT IN
>
NOT
>=
<
<=

SQL Course | Filtering Data


WHERE
operators

Comparison Logical Range Membership Search


Operators Operators Operator Operator Operator

= AND BETWEEN IN LIKE


<> =! OR NOT IN
>
NOT
>=
<
<=

SQL Course | Filtering Data | Comparison Operators


Comparison
Operators

= Checks if two values are equal

<> != Checks if two values are not equal

> Checks if a value is greater than another value.

>= Checks if a value is greater than or equal to another value

< Checks if a value is less than another value

<= Checks if a value is less than or equal to another value

SQL Course | Filtering Data | Comparison Operators


SQL Course | Filtering Data | Comparison Operators
SQL Course | Filtering Data | Comparison Operators
WHERE
operators

Comparison Logical Range Membership Search


Operators Operators Operator Operator Operator

= AND BETWEEN IN LIKE


<> =! OR NOT IN
>
NOT
>=
<
<=

SQL Course | Filtering Data | Logical Operators


Logical
Operators

AND All conditions must be TRUE

OR At least one condition must be TRUE

NOT (Reverse) Excludes matching values

BETWEEN Check if a value is within a range

IN Check if a value exists in a list

LIKE Search for a pattern in text

SQL Course | Filtering Data | Logical Operators


SQL Course | Filtering Data | AND Operator
SQL Course | Filtering Data | OR Operator
SQL Course | Filtering Data | NOT Operator
WHERE
operators

Comparison Logical Range Membership Search


Operators Operators Operator Operator Operator

= AND BETWEEN IN LIKE


<> =! OR NOT IN
>
NOT
>=
<
<=

SQL Course | Filtering Data | BETWEEN Operator


SQL Course | Filtering Data | BETWEEN Operator
WHERE
operators

Comparison Logical Range Membership Search


Operators Operators Operator Operator Operator

= AND BETWEEN IN LIKE


<> =! OR NOT IN
>
NOT
>=
<
<=

SQL Course | Filtering Data | IN & NOT IN Operators


SQL Course | Filtering Data | IN & NOT IN Operators
WHERE
operators

Comparison Logical Range Membership Search


Operators Operators Operator Operator Operator

= AND BETWEEN IN LIKE


<> =! OR NOT IN
>
NOT
>=
<
<=

SQL Course | Filtering Data | LIKE Operator


SQL Course | Filtering Data | LIKE Operator

You might also like