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!

Instagram

Also check out our Instagram page. We appreciate your like or comment. Feel free to share this post with your friends.