Retrieving All the data
we can retrieve all the data using the “SELECT * ” . Syntax is select that is followed by asterisk ( * ), space, From keyword and the Table Name from which you are going to fetch the data.
syntax:
SELECT * FROM TABLE NAME;
Example:
SELECT * FROM students;
We can observe that we have retrieved whole data i.e the 4 records of the table by using select* and the fetched column include stu_id, first_name, fees and email.
Output:
SQLite SELECT Query
SQLite is a serverless, popular, easy-to-use, relational database system that is written in c programming language. SQLite is a database engine that is built into all the popular devices that we use every day of our lives including TV, Mobile, and Computer.
As we know that we create the tables in the database and insert the data into them to store the data but, what is the use of storing the data without fetching the data? So let us learn how to retrieve the data from the database. Here comes the SELECT QUERY which is used to fetch the data from the database and in this article we are going to discuss SQLite SELECT Query. After reading this article we will gain knowledge about the Select Query.