โ
๐ Essential SQL Commands & Functions Cheatsheet ๐งโ๐ป
Whether beginner or prepping for data roles, mastering these essentials helps a lot! ๐ก
โฌ๏ธ Quick SQL reference:
1) SELECT โ Retrieve data
2) WHERE โ Filter rows by condition
3) GROUP BY โ Aggregate by column(s)
4) HAVING โ Filter aggregated groups
5) ORDER BY โ Sort results
6) JOIN โ Combine tables
7) UNION โ Merge query results
8) INSERT INTO โ Add new records
9) UPDATE โ Modify records
10) DELETE โ Remove records
11) CREATE TABLE โ Make a new table
12) ALTER TABLE โ Modify table structure
13) DROP TABLE โ Delete a table
14) TRUNCATE TABLE โ Remove all rows
15) DISTINCT โ Get unique values
16) LIMIT โ Restrict result count
17) IN / BETWEEN โ Filter by multiple values/ranges
18) LIKE โ Pattern match
19) IS NULL โ Filter NULLs
20) COUNT()/SUM()/AVG() โ Aggregate functions
โ
Save & save time in your next SQL task! ๐
Data Analytics Resources: https://whatsapp.com/channel/0029VaGgzAk72WTmQFERKh02
๐ React โฅ๏ธ for more
Post #2393
8.94K
- โค 21