1. SELECT Basic Statement
-- SQL SELECT Syntax
SELECT column_name, column_name, *
FROM table_name;
If we want to only get the distinct value, we could use DISTINCT keywords
--DISTINCT
SELECT DISTINCT column_name
FROM table_name;
--SQL WHERE Syntax
SELECT col1, col2,
FROM table
WHERE col_name operator value;
Operator | Description |
---|---|
= | Equal |
<> | Not Equal |
> | Greater than |
< | Less than |
>= | Greater than/equal |
<= | Less than /equal |
BETWEEN | A range |
LIKE | Search for a pattern |
IN | to specify multiple possible values for a column |
AND & OR in WHERE Clause
AND: for both first condition AND second condition on Where is true
OR: for either first condition OR second condition in Where is true;
SQL ORDER BY keyword
-- SQL ORDER BY Syntax
SELECT colname, colname2
FROM tablename
WHERE condition
ORDER BY colname ASC|DESC
2. SQL INSERT INTO Statement
--SQL INSERT INTO syntax
INSERT INTO tablename
VALUES(value1, value2, value3,....);
--Specify tablename, colname and value
INSERT INTO tablename(col1, col2, col3,...)
VALUES(val1, val2, val3,...)
3. SQL UPDATE statement
--SQL UPDATE Syntax
UPDATE tablename
SET col1 = value1, col2 = val2, ...
WHERE someCol = someVal
Note: Be careful with the Where condition.
4. SEL DELETE Statement
Delete records in a table
--DELETE Syntax
DELETE FROM tableName
WHERE somecol = someval