The frequently used SQL commands:

The purpose of this post is to have a quick reference for SQL syntax.

Select Statement

SELECT "column_name"
FROM "table_name";

Distinct

SELECT DISTINCT "column_name"
FROM "table_name";

Where

SELECT "column_name"
FROM "table_name"
WHERE "condition";

And/Or

SELECT "column_name"
FROM "table_name"
WHERE "simple condition"
{[AND|OR] "simple condition"};

In

SELECT "column_name" FROM "table_name"
WHERE "column_name" IN ('value1', 'value2', ...);

Between

SELECT "column_name"
FROM "table_name"
WHERE "column_name" BETWEEN 'value1' AND 'value2';

Like

SELECT "column_name"
FROM "table_name"
WHERE "column_name" LIKE {PATTERN};

Order By

SELECT "column_name"
FROM "table_name"
[WHERE "condition"]
ORDER BY "column_name" [ASC, DESC];

Count

SELECT COUNT("column_name")
FROM "table_name";

Group By

SELECT "column_name1", SUM("column_name2")
FROM "table_name"
GROUP BY "column_name1";

Having

SELECT "column_name1", SUM("column_name2")
FROM "table_name"
GROUP BY "column_name1"
HAVING (arithematic function condition);

Create Table Statement

CREATE TABLE "table_name"
("column 1" "data_type_for_column_1",
"column 2" "data_type_for_column_2",... );

Drop Table Statement

DROP TABLE "table_name";

Truncate Table Statement

TRUNCATE TABLE "table_name";

Insert Into Statement

INSERT INTO "table_name" ("column1", "column2", ...)
VALUES ("value1", "value2", ...);

Update Statement

UPDATE "table_name"
SET "column_1" = [new value]
WHERE {condition};

Delete From Statement

DELETE FROM "table_name"
WHERE {condition};