SQL Commands - Minimal CheatSheet 2024

[x32x01]

SQL is a standard language for accessing and manipulating databases.
Although SQL is an ANSI/ISO standard, there are different versions of the SQL language.
However, to be compliant with the ANSI standard, they all support at least the major commands (such as SELECT, UPDATE, DELETE, INSERT, WHERE) in a similar manner.

1. DELETE – DELETE statements are used to remove rows from a table
2. GROUP BY – GROUP BY is used with SELECT to arrange identical data into groups
3. HAVING – HAVING was added to SQL because WHERE could not be used with aggregate functions
4. INNER JOIN – An inner join will combine rows from different tables if the join condition is true
5. INSERT – INSERT statements are used to add a new row to a table
6. IS (NOT) Null – IS Null and IS NOT NULL are operators used with WHERE to test for empty values
7. LIKE – LIKE is a special operator used with WHERE to search for a specific pattern in a column
8. LIMIT – LIMIT lets you specify the maximum number of rows the result set will have
9. SUM() – SUM() returns the sum of all the values in a column
10. UPDATE – UPDATE statements allow you to edit rows in a table
11. WHERE – WHERE filters the result set to include only rows where the following condition is true
12. WITH – WITH stores the result of a query in a temporary table using an alias
13. OUTER JOIN – An outer join will combine rows from different tables in any conditions
14. ROUND() – ROUND rounds the values in a column to the number of specific decimal places
15. SELECT – SELECT is used to fetch data from a database
16. SELECT DISTINCT – SELECT DISTINCT returns unique values in the specified column(s)
17. BETWEEN – The BETWEEN operator is used to filter the result set within a certain range
18. CASE – CASE statements are used to create different outputs.
19. COUNT() – COUNT() is a function that counts the number of rows where a column is not null
20. CREATE TABLE – CREATE TABLE creates a new table in the database
21. ALTER TABLE – ALTER TABLE lets you add columns to a table in a database
22. AND – AND is an operator that combines two conditions
23. AS – AS allows you to rename a column or table using an alias
24. AVG() – AVG() is an aggregate function that returns the average value for a numeric column
25. MAX() – MAX() is a function that returns the largest value in a column
26. MIN() – MIN() is a function that returns the smallest value in a column
27. OR – OR is an operator that combines two conditions
28. ORDER BY – ORDER BY sorts that result set by a particular column either alphabetically or numerically