SQL types

SQL types

1. DDL

   • CREATE
   • ALTER
   • DROP

2. DQL

   • SELECT
     • Funçoes de agregaçao
       • max
       • min
       • sum
       • Nao se usa funçoes de agregaçao no "WHERE"
       • AVG
       • COUNT
       • GROUP BY
         • HAVING
       • ALIAS: AS
   • alguns autores consideram SELECT um DML

3. DCL

   • GRANT
   • REVOKE
   • DENY

4. DML

   • INSERT
   • DELETE
   • UPDATE

5. DTL

   • ROLLBACK
   • COMMIT
   • BEGIN TRANSACTION