SQL SERVER -- DRL Commands -- Part-5

DRL Commands:-
                                               DRL Stands for Data Retrieval Language and these commands are used to view data available in tables or views.

SELECT– This command is used to Retrieve the data from Tables or views.

-- How to Retrieve All the Columns from the Table

USE SQLSERVER

GO

SELECT * FROM EMP

-- How to Retrieve few Columns from the Table

USE SQLSERVER

GO

SELECT EMPNAME,SAL FROM EMP