Databases for Windows / Database Blog / Organizer Advantage, Handy Library, SQL Tutor / SQL Select / SQL Tutor, Select Where Clouse, IN
28/05/2024SQL SELECT, WHERE clause, IN operator
SQL SELECT, WHERE clause, IN operator
When you define the condition in the WHERE clause, you can use the IN operator. After the IN you define the list of values.
Where condition, IN operator, syntax
SELECT * FROM books WHERE category IN (value1, value2, value3, …);
SELECT title, author FROM books WHERE category IN (value1, value2, value3, …);
SELECT title, author FROM books WHERE category IN (value1, value2, value3, …);
SELECT statement with WHERE, IN operator, examples
SELECT title, author FROM books WHERE category IN (‘Science’,’Geography’,’Bilology’);
Database Blog
Firebird SQL Tutor
SQL Select
- Select, Where
- Select, Where Compare
- Select, Where Equal
- Select, Where Greater Than
- Select, Where Less Than
- Select, Where Greater Than, Equal
- Select, Where Less Than, Equal
- Select, Where Not Equal
- Select, Where Between
- Select, Where IN
- Select, Where LIKE
- Select, Where Wildcards
SQL Select AND, OR, NOT
SQL Select ORDER BY
SQL Select DISTINCT
SQL FUNCTIONS
- Functions, Count
- Functions, Sum
- Functions, Avg
SQL RESERVED WORDS
SQL UPDATE
Database Software for Windows:
Handy Managers
Organizer Advantage
Label Printer Advantage
Organizer Advantage Database:
Organizer Advantage, Simple Database Solutions
Organizer Advantage, Business Database Solutions
Copyright © 2024 · All Rights Reserved · PrimaSoft PC