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;





0 comments:

hits count
Database | Oracle PartnerNetwork Blog