My SQL Journey

Day 3 of my SQL Journey...

Today's learning was majorly a lab practice (as it is usually called) which I would be posting later on alongside my project on SQL, do anticipate. Nonetheless, here is a little theoretical aspect of today's learning;

The SQL SELECT Statement

The SELECT statement is used to select data from a database.

The data returned is stored in a result table, called the result-set.

SELECT Syntax

SELECT column1, column2, ...

FROM table_name;

Here, column1, column2, ... are the field names of the table you want to select data from. If you want to select all the fields available in the table, use the following syntax:

SELECT * FROM table_name;

I know it's not much theory today, this is because I have to learn and practice what I have learned as well. I will show you all soon all I have practiced at the end of this journey. Stick with me and see you next time.