Data Retrieval

The primary function of database is to store and provide to user request. In SSMS, The Select statement provides the data retrieval functionality.

SELECT Statement:

It is powerful query statement responsible for extract data from table or more then one table.

Syntax :

Select/[Distinct]/ 
<*/Col1,Col2,Col3,.......n>
From <Table_Name>

Example :

 
SELECT * FROM student;

In Select statement must have at least a Select clause and a From clause.
Must of case select statement retrieves all columns and all rows from table. That time we are using asterisk (*). but If you want to select some specific columns then follow the below example.

Example :

 
SELECT ID, Name FROM student;