Blog
SQLite SELECT Statement
SQLite SELECT Statement
The SQLite SELECT statement retrieves records from a database table. This tutorial explains the syntax and provides examples of usage.
Syntax
The general syntax of the database statement is as follows:
To retrieve all the columns of the table:
/> SELECT * FROM table_name;
We can specify the column names we want to retrieve in the SELECT statement.
The following syntax retrieves only the specified columns from the table.
/> SELECT column1, column2, … FROM table_name;
Example
For example, to retrieve all the columns of the emp database table, we can use the following command:
sqlite> SELECT * FROM emp ;
sqlite>
sqlite> — SQLite SELECT Statement
SQLite Tutorials
SQLite tutorials on this website: