In SQLite database, SELECT statement is used to fetch data from a table. When we create a table and insert some data into that, we have to fetch the data whenever we require. That's why select query is used.
SELECT column1, column2, columnN FROM table_name;
Here, column1, column2...are the fields of a table, which values you have to fetch. If you want to fetch all the fields available in the field then you can use following syntax:
SELECT * FROM table_name;
Let's see an example:
SELECT * FROM STUDENT;