1. Select

• Retrieval of data from a table by providing table name which is present in database.

2. Projection

• Retrieval of data from the table by providing the column name which is present in execution area.

3. Selection

• Retrieval of data from the table by providing both column name and row name.

4. Join

• Retrieval of data from multiple tables simultaneously.

Example:

Projection Statement:

Gets the column name from the table

Syntax:

Select */[Distinct], col_name/Expression[Alias_name]

Select Statement:

syntax:

Select */Col_name From 

Functionality of from clause

• Goes to the table, search for the table name and put it into execution area.
• In from clause we should take only the table name.

Functionality of from clause