SQLite – SELECT Query SQLite SELECT statement is used to fetch the data from a SQLite database table which returns data in the form of a result table. These result tables are also called result sets. Syntax Following is the basic syntax of SQLite SELECT statement. SELECT column1, column2, columnN FROM table_name; Here, column1, column2 […]
Category Archives: sqlite
SQLite – Operators What is an Operator in SQLite? An operator is a reserved word or a character used primarily in an SQLite statement”s WHERE clause to perform operation(s), such as comparisons and arithmetic operations. Operators are used to specify conditions in an SQLite statement and to serve as conjunctions for multiple conditions in a […]
SQLite – WHERE Clause SQLite WHERE clause is used to specify a condition while fetching the data from one table or multiple tables. If the given condition is satisfied, means true, then it returns the specific value from the table. You will have to use WHERE clause to filter the records and fetching only necessary […]