Introduction to SQL.

 The Structured Query Language shortly known as SQL, is a database language used for the purpose of managing data in relational database, with the help of Relational Algebra. Its main tasks  includes data query , data update, schema creation and modification, and data access control.

 The SELECT statement:

General Syntax:

SELECT *|{[DISTINCT] column|expression [alias]...}

FROM table;

To get all rows from the table:

SELECT * FROM emp;

To get specific rows from a table:

SELECT name, empid FROM emp;