SQL Knowledge Center Β· About Β·
Easy Interactive Online SQL Training for Beginners

SQL IN Tutorial - Interactive Database Lesson

Lesson 8 of 31

Lessons

1. SELECT *
2. SELECT specific columns
3. WHERE ... Equals
4. WHERE ... Greater than
5. WHERE ... Greater than or equal
6. AND
7. OR
8. IN
9. DISTINCT
10. ORDER BY
11. LIMIT # of returned rows
12. COUNT(*)
13. COUNT(*) ... WHERE
14. SUM
15. AVG
16. MAX and MIN
17. GROUP BY
18. Nested queries
19. NULL
20. Date
21. Inner joins
22. Multiple joins
23. Joins with WHERE
24. Left joins
25. Table alias
26. Column alias
27. Self joins
28. LIKE
29. CASE
30. SUBSTR
31. COALESCE

IN

Interactive SQL Tutorial

Using the WHERE clause, we can find rows where a value is in a list of several possible values.

SELECT * FROM friends_of_pickles WHERE species IN ('cat', 'human'); would return the friends_of_pickles that are either a cat or a human.

To find rows that are not in a list, you use NOT IN instead of IN.

Can you run a query that would return the rows that are not cats or dogs?

SQL:

Query Result:

Available Tables:

Languages: English, EspaΓ±ol, Portoghese, Italiano, FranΓ§ais, ζ—₯本θͺž, Deutsch, Ψ§Ω„Ω„ΨΊΨ© Ψ§Ω„ΨΉΨ±Ψ¨ΩŠΨ©

2017 - 2023 Β· SQL-Easy.com. A Beekeeper Studio Project.

About Β· Cookie Policy Β· Terms of Use

πŸš€ Learn Advanced SQL