SQL STATEMENT TYPES

Types Sql

SQL statement are five types

 - Data retrieval. Data . data retrieval statement retrieve data from database. SQL SELECT statement can retrieve data from one or more table

- Data manipulation. (DML) make changes to data in the database .use insert to enter new rows, UPDATE to change existing rows,DELETE to remove    rows from a database   

 - Data definition. (DDL) manipulate the structure of a database. CREATE new table, RENAME changes the name of a table. ALTER changes table structures. DROP removes an entire table from database.

 - Transaction control. Are used to manage changes made in DML statements .Commit  Accepts a change      and ROLLBACK reverses a change made in A DML transaction .SAVEPOINT creates a marker within     transaction 

 - Data control. DCL statement control user access to the database .GRANT and REVOKE are DCL statements that give or remove access rights to an database.