SQL SELECT Statement

In this tutorial, we will learn how to use the SELECT Statement in SQL Query with an example.

The SELECT QUERY is used to select data from the database table.

Syntax:

SELECT column1, column2, columnN FROM table_name;

In the above SELECT syntax, column1, column2,... are the name of those columns in the table whose data we want to fetch.

If you want to select all the fields available in the table, use the following syntax:

SELECT * FROM table_name;

Database Example

Consider the student table having the following records:−

Run Select Query with the above records.

SELECT * FROM `student`;

it will return all records of the student table.

If we required only Student_ID and First_Name from the above Student table. then our SQL Query will be.

SELECT Student_ID, First_Name  FROM `student`;

Output: