TechnoLearnAcademy

TECHNOLEARN

SQL SELECT Statement

The SELECT Statement is used to retrieve the data from the Database table.
The Select Statement retrieves the data in a tabular form.

Syntax:

SELECT * FROM  tablename;
Note: (*) is used to retrieve all the columns from the table.
Let’s understand the select statement with an example. For the purposes of this demonstration, we will be utilizing the employee table.

Example:

   Objective: Select all the Columns from the Tbl_Emp.
                      SELECT * FROM Tbl_Emp;
    Output:

Example:

   Objective: Select specific columns from the Tbl_Emp. In this example , we will select only firstname , lastname , salary                              from the tbl_emp
                      SELECT FirstName, LastName , Salary FROM Tbl_Emp;
    Output:
Scroll to Top