SQLite SELECT Query

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.

Syntax:

1. 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:

1. SELECT * FROM table_name;   

Let's see an example:

1. SELECT * FROM STUDENT;