Introduction
In this tutorial, we want to select data from a table by using a SQL Statement. In order to do this, we use the SELECT Statement.
We have already created the table student with the following data:
Example 1 - SELECT specific columns
We want to select the columns name and birthdate.
In order to do this, we execute the following SQL statement:
SELECT name, birthdate
FROM student;The following selection is returned:
Example 2 - SELECT all columns
Now, we want to select all columns available in the table student.
In order to do this, we execute the following SQL statement:
SELECT * FROM student;The following selection is returned:
Conclusion
Congratulations! Now you are one step closer to become an AI Expert. You have seen that it is very easy to select data from a table with the SELECT Statement. Try it yourself!
Also check out our Instagram page. We appreciate your like or comment. Feel free to share this post with your friends.
