Javatpoint Logo
Javatpoint Logo


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.


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:

SQLite Select query 1

Youtube For Videos Join Our Youtube Channel: Join Now

Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Trending Technologies

B.Tech / MCA