![]() In this tutorial, you have learned how to use the SQLite IN operator to match a value with a list of values or a subquery. Genreid NOT IN ( 1, 2, 3) Code language: SQL (Structured Query Language) ( sql ) The following statement returns a list of tracks whose genre id is not in a list of (1,2,3). Then, the outer query return all tracks whose album id matches with the album id list returned by the subquery. To show tables in a database using the sqlite command-line shell program, you follow these steps: First, open the database that you want to show the tables: sqlite3 c:\sqlite\db\chinook.db Code language: SQL (Structured Query Language) (sql) The above statement opened the database named chinook.db that locates in the c:\sqlite\db directory.First, the subquery returns a list of album ids that belong to the artist id 12.) Code language: SQL (Structured Query Language) ( sql ) To get the tracks that belong to the artist id 12, you can combine the IN operator with a subquery as follows: SELECT To show tables in a database using the sqlite command-line shell program, you follow these steps: First, open the database that you want to show the tables: sqlite3 c:sqlitedbchinook. WHERE artistid = 12 Code language: SQL (Structured Query Language) ( sql ) The following query returns a list of album id of the artist id 12: SELECT albumid SQLite IN operator with a subquery example If you have a query that uses many OR operators, you can consider using the IN operator instead to make the query more readable. MediaTypeId = 1 OR MediaTypeId = 2 ORDER BY Name ASC Code language: SQL (Structured Query Language) ( sql )Īs you can see from the queries, using the IN operator is much shorter. This query uses the OR operator instead of the IN operator to return the same result set as the above query: SELECT ORDER BY Name ASC Code language: SQL (Structured Query Language) ( sql ) The SHOW TABLES command can be used to obtain a list of all tables within the selected schema. The following statement uses the IN operator to query the tracks whose media type id is 1 or 2. We will use the Tracks table from the sample database for the demonstration. To negate the list of values, you use the NOT IN operator. The IN operator returns true or false depending on whether the expression matches any value in a list of values or not. ![]() The returned type of expression and values in the list must be the same. ![]() The expression can be any valid expression or a column of a table.Ī list of values is a fixed value list or a result set of a single column returned by a subquery. The syntax of the IN operator is as follows: expression IN (value_list|subquery) Code language: SQL (Structured Query Language) ( sql ) The SQLite IN operator determines whether a value matches any value in a list or a subquery. Learn how to create, destroy, manage, and use databases and tables using SQLite. Summary: in this tutorial, you will learn how to use the SQLite IN operator to determine whether a value matches any value in a list of values or a result of a subquery. Learn how to create, destroy, manage, and use databases and tables using SQLite.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |