Posts

Showing posts from February, 2024

JOINS

 JOIN/INNER JOIN OUTER JOIN LEFT JOIN RIGHT JOIN FULL JOIN CROSS JOIN

Clauses

 SELECT WHERE GROUP BY HAVING DISTINCT GROUPING SETS ORDER BY Clause ORDER BY ASC/DESC AND OR  AS  WITH IN BETWEEN  ANY LIKE 

Operators

 LIKE EXIST BETWEEN IS NUL IS NOT NULL NOT IN UNION UNION ALL INTERSECT COMPARISON MINUS/EXCEPT 

Aggregate Functions

 MIN() MAX() SUM() AVG() COUNT() FIRST() LAST()

DML

 INSERT UPDATE DELETE SELECT

DDL

 CREATE ALTER TRUNCATE DROP RENAME

SQL Commands

Image