✅ Basic SQL Commands Cheat Sheet 🗃️

⦁  SELECT — Select data from database
⦁  FROM — Specify table
⦁  WHERE — Filter query by condition
⦁  AS — Rename column or table (alias)
⦁  JOIN — Combine rows from 2+ tables
⦁  AND — Combine conditions (all must match)
⦁  OR — Combine conditions (any can match)
⦁  LIMIT — Limit number of rows returned
⦁  IN — Specify multiple values in WHERE
⦁  CASE — Conditional expressions in queries
⦁  IS NULL — Select rows with NULL values
⦁  LIKE — Search patterns in columns
⦁  COMMIT — Write transaction to DB
⦁  ROLLBACK — Undo transaction block
⦁  ALTER TABLE — Add/remove columns
⦁  UPDATE — Update data in table
⦁  CREATE — Create table, DB, indexes, views
⦁  DELETE — Delete rows from table
⦁  INSERT — Add single row to table
⦁  DROP — Delete table, DB, or index
⦁  GROUP BY — Group data into logical sets
⦁  ORDER BY — Sort result (use DESC for reverse)
⦁  HAVING — Filter groups like WHERE but for grouped data
⦁  COUNT — Count number of rows
⦁  SUM — Sum values in a column
⦁  AVG — Average value in a column
⦁  MIN — Minimum value in column
⦁  MAX — Maximum value in column

💬 Tap ❤️ for more!