1)Select:
This command is used to retrieve data from data base.
Syntax:
1) select * from <table-name>;
Ex:- select * from employee_ table;
2) select <column1_name>,<column2_name>,…..,<column_name>
from <table_name>;
Ex:- select emp_name, emp_Add,
emp_phone from employee_table;
Observe the above two syntaxes ,
first one is used to retrieve all columns data from specified table and the
second one is used to retrieve specified column(s) data from specified table.
