SQL Rules Data Retrieval- SELECT DML (Data Manipulation Language)- INSERT, UPDATE, DELETE, MERGE Data definition language (DDL)- CREATE, ALTER, DROP, RENAME, TRUNCATE Transaction control- COMMIT, ROLLBACK, SAVEPOINT Data control language (DCL)- GRANT, REVOKE SQL SELECT Statements Arithmetic Expressions Operator + Add - Subtract * Multiply / Divide Using Arithmetic Operators: SELECT last_name, salary, salary + 300 FROM employees; Operator Precedence: •Multiplication and division…
Words 909 - Pages 4