SQLite Join Summary: in this tutorial, you will learn about various kinds of SQLite joins to query data from two or more tables. For the demonstration, we will use the artists and albums tables from the sample database. An artist can have zero or many albums while an album belongs to one artist. To query…
Read more
SQLite IS NULL Summary: in this tutorial, you will learn how to use the SQLite IS NULL and IS NOT NULL operators to check whether a value is NULL or not. Introduction to the SQLite IS NULL operator NULL is special. It indicates that a piece of information is unknown or not applicable. For example,…
Read more
SQLite GLOB Summary: in this tutorial, you will learn how to use the SQLite GLOB operator to determine whether a string matches a specific pattern. Introduction to the SQLite GLOB operator The GLOB operator is similar to the LIKE operator. The GLOB operator determines whether a string matches a specific pattern. Unlike the LIKE operator,…
Read more
SQLite LIKE Summary: in this tutorial, you will learn how to query data based on pattern matching using SQLite LIKE operator. Introduction to SQLite LIKE operator Sometimes, you don’t know exactly the complete keyword that you want to query. For example, you may know that your most favorite song contains the word,elevator but you don’t…
Read more
SQLite IN 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. Introduction to the SQLite IN operator The SQLite IN operator determines whether a value matches any value in a list…
Read more
SQLite BETWEEN Summary: in this tutorial, you will learn how to use the SQLite BETWEEN operator to test whether a value is in a range of values. Introduction to SQLite BETWEEN Operator The BETWEEN operator is a logical operator that tests whether a value is in range of values. If the value is in the…
Read more
SQLite Limit Summary: in this tutorial, you will learn how to use SQLite LIMIT clause to constrain the number of rows returned by a query. Introduction to SQLite LIMIT clause The LIMIT clause is an optional part of the SELECT statement. You use the LIMIT clause to constrain the number of rows returned by the…
Read more
SQLite Where Summary: in this tutorial, you will learn how to use SQLite WHERE clause to specify the search condition for rows returned by the query. Introduction to SQLite WHERE clause The WHERE clause is an optional clause of the SELECT statement. It appears after the FROM clause as the following statement: SELECT column_list FROM…
Read more
SQLite Select Distinct Summary: in this tutorial, you will learn how to use the SQLite SELECT DISTINCT clause to remove duplicate rows in the result set. Introduction to SQLite SELECT DISTINCT clause The DISTINCT clause is an optional clause of the SELECT statement. The DISTINCT clause allows you to remove the duplicate rows in the result…
Read more
SQLite Order By Summary: in this tutorial, you will learn how to sort a result set of a query using SQLite ORDER BY clause. Introduction to SQLite ORDER BY clause SQLite stores data in the tables in an unspecified order. It means that the rows in the table may or may not be…
Read more