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:

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:

Let's see an example: