SELECT Query in SQLite

by

SQLite SELECT Query
To fetch data from a table, the SELECT statement is used in SQLite.

Syntax 1: To select specific fields from a table. 

SELECT column_1, column_2, column_N   
FROM table_name   
WHERE expression;

Syntax 2: To select all fields from a table. 

SELECT * FROM table_name;

Example: 

SELECT * FROM TEACHERS;

Output:

ID NAME SUBJECT
1 Jim English
2 John Geology
3 Watson French
4 Holmes Chemistry
5 Tony Physics

Explanation:
The “TEACHERS” is an already existing table. Here we are selecting all the fields of the table.