SQL Cheat Sheet by Bandeshah, Study notes of Computer science

Download SQL Cheat Sheet by Bandeshah and more Study notes Computer science in PDF only on Docsity! SQL QUERIES CHEAT SHEET AS 9618. DML 1. To select certain records in a data base, keywords, Display/Return/Show… SELECT column1, column2, ... FROM table_name WHERE condition; ORDER BY column1, column2, ... ASC|DESC; 2. To insert new record(s) in a Table INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...); 3. Modify existing record(s) in Table UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition; 4. Delete Record(s) from the Table DELETE FROM table_name WHERE condition; 5. Returns the number of rows which matches the criteria SELECT COUNT(column_name) FROM table_name WHERE condition; 6. Returns the average value of a numeric column. SELECT AVG(column_name) FROM table_name WHERE condition; 7. Returns the total sum of a numeric column. SELECT SUM(column_name) FROM table_name WHERE condition; 8. Selects records that have matching values in both tables. SELECT column_name(s) FROM table1 INNER JOIN table2 ON table1.column_name = table2.column_name; OR SELECT column_name(s) FROM table1, table2 AND table1.column_name = table2.column_name; 9. Groups rows that have the same values into summary rows, like "find the number of customers in each country". SELECT column_name(s) FROM table_name WHERE condition GROUP BY column_name(s) DDL 1. Statement is used to create a new SQL database. CREATE DATABASE databasename; 2. Statement is used to drop an existing SQL database. DROP DATABASE databasename; 3. To Drop Table