Tech Articles

SQL Commands – Minimal Cheatsheet 2020

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
Step by step hacking tutorials about wireless cracking, kali linux, metasploit, ethical hacking, seo tips and tricks, malware analysis and scanning.