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;
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;
