sql-query

SQL Query

SQL stands for Structured Query Language. The idea was to define a common method of storing data that would allow you to retrieve specific information without detailed knowledge of the underlying database engine.

In Oracle, SQL is divided into two basic groups:
data definition language (DDL) or data manipulation language (DML). DDL is used to define objects within the database just as creating tables or indexes. DML is used to insert, update and delete data in the database. Finally, there is data retrieval, which is the SELECT statement.

The SELECT statement

The SELECT statement is used to retrieve data from the database. The format is:

 select * from emp;

More about Sql Query..

DISTINCT	EXISTS	GROUP BY
HAVING	Like	Order By