SQL Server Transact Basic to Expert - Select Query

Idea behind this series of blog is to have a place for SQL Server starting from basic level to expert level on all the topics covered for developers.

Select Statement:

Used to retrived a set of data from the table

Syntax:

SELECT Column_List
FROM table

Example:

SELECT EmpName, EMPId, EMPSal
FROM EMPTable