SQL Basic Statement(INSERT/DELETE/UPDATE/SELECT)

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;

 WHERE Clause is used to filter records.

 

--SQL WHERE Syntax
SELECT col1, col2,
FROM table
WHERE col_name operator value;

Operators in the WHERE Clause

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