All commands of sql fall in one of the following categories.
- DDL (Data Definition Language)
These statements are used to create tables and databases and define field properties or table properties. Examples of commands that fall in this category are CREATE,ALTER and DROP statements
2. DML (Data Manipulation Language)
The statements that falls under this category are used to update data or add or remove data from tables. UPDATE, DELETE and INSERT commands fall under this category.
3. DCL (Data Control Language)
It is used to control who access the data. The commands that come under this category are GRANT and REVOKE
4. TCL (Transaction Control Language)
This language is used to commit data and restore data. COMMIT and ROLLBACK falls under this category.
5. DQL (Data Query Language)
This is to retrieve data from sql server. SELECT statement falls in this category.
All above languages are SQL. They are just categories of SQL. they are not different from SQL.