Basic SQL commands cheat sheet📋

1- SELECT

• Select data from database.

2- FROM

• Specify table we're puling from.

3- WHERE

• Filter query to match a condition.

4- AS

• Rename column or table with alias.

5- JOIN

• Combine rows from 2 or more tables.

6- AND

• Combine query conditions. All must be met.

7- OR

• Combine query conditions. One must be met.

8- LIMIT

• Limit rows returned. See also FETCH & TOP.

9- IN

• Specify multiple values when using WHERE.

10- CASE

• Return value on a specified condition.

11- IS NULL

• Return only rows with a NULL In.

12- LIKE

• Search for patterns in column.

13- COMMIT

• Write transaction to database.

14- ROLLBACK

• Undo a transaction block.

15- ALTER TABLE

• Add/Remove columns from table.

16- UPDATE

• Update table data.

17- CREATE

• Create TABLE, DATABASE, INDEX or VIEW.

18- DELETE

• Delete rows from table.

19- INSERT

• Add single row to table.

20- DROP

• Delete TABLE, DATABASE or INDEX.

21- GROUP BY

• Group data into logical sets.

22- ORDER BY

• Set order of result. Use DESC to reverse order.

23- HAVING

• Same as WHERE but filters groups.

24- COUNT

• Count number of rows.

25- SUM

• Return sum of column.

26- AVG

• Return average of column.

27- MIN

• Return min value of column.

28- MAX

• Return max value of column.

Connect with Me 😊

🔗 Links