Sql Sintaxe (syntax)

Referência rápida a sintaxe das clausulas SQL. Acesse o link no fim do post para informações mais detalhadas.

Select Statement
SELECT "column_name" FROM "table_name"

Where
SELECT "column_name"
FROM "table_name"
WHERE "condition"

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 '%PEDACO_DA_PALAVRA%'

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

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

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}

Fonte: http://www.1keydata.com/sql/sql-syntax.html