Retrieving Data from Table   :-

  • “Select “command is used to retrieve data from table.
  • “Select” command is used to the following operations.

(i)  Select
(ii)  Project                    
(iii)  Join
(iv) Set operations -> union, intersect

These operations are data retrieval operations.

SELECT  :-

  • Selecting particular records from Table.

Example   :- sal>200

Project   :

  • Selecting particular columns from table

Example: – enameπ, sal(emp)

JOIN

  • Greeting data from multiple tables.

Syntax:                 

    Select<collist>

    From<tabname>

   Example   : Display ename and salaries

Select ename, sal from emp

  • Display all the data from emp table

Select * from EMP

  • By default Sql server doesn’t column headings for derived columns

Select ename, sal, sal*12  From emp

Ename             sal          no column name

A                     500           6000

B                      600           7200

C                      700            8400